Interior Decorating

The Interior object is your object of interest if you need to modify the background or interior of a range or other object. The Interior object is your programmatic equivalent of the Patterns tab of the Format Cells dialog box (see Figure 10.4).

The Interior object is used for two types of activities: changing the color of a range or changing the background pattern of a range. Table 10.3 lists the handful of useful properties you may need to use. Note, this list is not inclusive of all of the properties of the Interior object, just the ones that you are most likely to use.

Table 10.3: Useful Interior Properties

Property Name description

Returns or sets the primary color of the interior using an RGB value.

Returns or sets the color of the interior using a color from the workbook's color palette.

Returns or sets the interior's pattern.

Color

ColorIndex

Pattern

PatternColorIndex

PatternColor

Returns or sets the color of the interior's pattern using an RGB value.

Returns or sets the color of the interior's pattern using a color from the workbook's color palette.

As you can see, there isn't much here. Most of the functionality here lies in the various patterns that can be created. It would probably be helpful to know what those patterns are. Listing 10.3 creates an example of each pattern available. As an added bonus, it also creates an example of each defined VB color constant (as listed in Table 10.1).

0 0

Post a comment