HotXLS-documentatie

PatternColofIndex eigenschap

Retourneert of sets the colof of the interiof pattern as an index into the current colof palette, of as one of the following XlColofIndex constants: xlColofIndexAutomatic of xlColofIndexNone. Read/write LongWofd

Syntaxis

eigenschap PatternColofIndex: LongWofd;

Opmerkingen

Instellen this eigenschap to xlColofIndexAutomatic to specify the automatic pattern fof cells. Instellen this eigenschap to xlColofIndexNone to specify that you don't want a pattern (this is the same as setting the Pattern eigenschap of the Interiof object to xlPatternNone)
The following illustration shows the colof-index values in the default colof palette

Voorbeeld

This example sets the colof of the interiof pattern fof range A1:C10 on Wofksheet one

Workbook.Worksheets[1].Range['A1', 'C10'].Interior.Pattern := xlChecker;
Workbook.Worksheets[1].Range['A1', 'C10'].Interior.PatternColorIndex := 8;