Class Interior (Excel VBA)

The class Interior represents the interior of an object.

Properties

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.

Charts("Chart1").Axes(xlValue).TickLabels.Font.Color = _ 
 RGB(0, 255, 0)

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.

Parent returns the parent object for the specified object. Read-only.

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

Worksheets("Sheet1").Range("A1"). _ 
 Interior.Pattern = xlPatternCrissCross

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

With Worksheets("Sheet1").Rectangles(1).Interior 
 .Pattern = xlGrid 
 .PatternColor = RGB(255,0,0) 
End With

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.

With Worksheets("Sheet1").Rectangles(1).Interior 
 .Pattern = xlChecker 
 .PatternColorIndex = 5 
End With

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.