Class Interior (Excel VBA)

The class Interior represents the interior of an object.

The classes AboveAverage, CellFormat, DisplayFormat, FormatCondition, OLEObject, Range, Style, TableStyleElement, Top10 and UniqueValues. give access to class Interior

Member in collection


To use a Interior class variable it first needs to be instantiated, for example

Dim int as Interior
Set int = ActiveCell.Interior

The following procedures can be used to set variables of type Interior: AboveAverage.Interior, CellFormat.Interior, DisplayFormat.Interior, FormatCondition.Interior, OLEObject.Interior, OLEObjects.Interior, Range.Interior, Style.Interior, TableStyleElement.Interior, Top10.Interior and UniqueValues.Interior.


Color returns or sets the primary color of the object, as shown in the table in the remarks section. Use the RGB function to create a color value.

ColorIndex returns or sets a value that represents the color of the interior.

Gradient returns or sets the Gradient property of an Interior object of a selection.

InvertIfNegative true if Microsoft Excel inverts the pattern in the item when it corresponds to a negative number.

Pattern returns or sets a Variant value, containing an XlPattern constant, that represents the interior pattern.

PatternColor returns or sets the color of the interior pattern as an RGB value.

PatternColorIndex returns or sets the color of the interior pattern as an index into the current color palette, or as one of the following XlColorIndex constants: xlColorIndexAutomatic or xlColorIndexNone. Read/write Long.

PatternThemeColor returns or sets a theme color pattern for an Interior object.

PatternTintAndShade returns or sets a tint and shade pattern for an Interior object.

ThemeColor returns or sets a Variant value, containing an XlThemeColor constant, that represents the color. Read/write Variant.

TintAndShade returns or sets a Single that lightens or darkens a color.

LinearGradient - The LinearGradient object transitions through a series of colors in a linear manner along a specific angle.