The Interior Object

The Interior object represents the characteristics of the interior region of a cell (or range of cells). The Interior object has only a handful of properties (and no methods), as described in this section.

19.4.8.1 Color and ColorIndex properties

These properties are analogous to the properties by the same name of the Borders object, discussed earlier. They set the interior of a cell (or cells) to the color specified.

19.4.8.2 Pattern property

This property returns or sets the interior pattern. It can be one of the following XlPattern constants:

Enum XlPattern xlPatternVertical = -4166 xlPatternUp = -4162 xlPatternNone = -4142 xlPatternHorizontal = -4128 xlPatternGray7 5 = -4126 xlPatternGray5 0 = -4125 xlPatternGray2 5 = -4124 xlPatternDown = -4121 xlPatternAutomatic = -4105 xlPatternSolid = 1 xlPatternChecker = 9 xlPatternSemiGray75 = 10 xlPatternLightHorizontal = 11 xlPatternLightVertical = 12 xlPatternLightDown = 13 xlPatternLightUp = 14 xlPatternGrid = 15 xlPatternCrissCross = 16

xlPatternGray16 = 17 xlPatternGray8 = 18 End Enum

Note that this provides another way to access grayscales. 19.4.8.3 PatternColor and PatternColorIndex properties

These properties set the color (or color index) of the pattern used to fill the interior of a cell. For more on setting color and color indexes, please see the discussion of the Color and ColorIndex properties of the Border object.

0 0

Post a comment