ColorFormat Object

Description

Represents the color of a one-color object, the foreground or background color of an object with a gradient or patterned fill, or the pointer color. You can set colors to an explicit red-green-blue value (by using the RGB property) or to a color in the color scheme (by using the SchemeColor property).

Using the ColorFormat Object

Use one of the properties listed in the following table to return a ColorFormat object.

To return a ColorFormat object that represents this


Use this property


With this object

Background fill color (used in a shaded or patterned fill)

BackColor

FillFormat

Foreground fill color (or simply the fill color for a solid fill)

ForeColor

FillFormat

Background line color (used in a patterned line)

BackColor

LineFormat

Foreground line color (or just the line color for a solid line)

ForeColor

LineFormat

Shadow color

ForeColor

ShadowFormat

Color of the sides of an extruded object

ExtrusionColor

ThreeDFormat


Use the RGB property to set a color to an explicit red-green-blue value. The following example adds a rectangle to myDocument and then sets the foreground color, background color, and gradient for the rectangle's fill.

Set myDocument = Worksheets(1)
With myDocument.Shapes.AddShape(msoShapeRectangle, 90, 90, 90, 50).Fill
    .ForeColor.RGB = RGB(128, 0, 0)
    .BackColor.RGB = RGB(170, 170, 170)
    .TwoColorGradient msoGradientHorizontal, 1
End With
Properties

Application property, Creator property, Parent property, RGB property, SchemeColor property, Type property.