ColorFormat Object
This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
.gif "Aa661359.parchild(en-us,office.10).gif") ColorFormat |
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.
| Use this property | With this object | To return a ColorFormat object that represents this |
|---|---|---|
| BackColor | FillFormat | The background fill color (used in a shaded or patterned fill) |
| ForeColor | FillFormat | The foreground fill color (or simply the fill color for a solid fill) |
| BackColor | LineFormat | The background line color (used in a patterned line) |
| ForeColor | LineFormat | The foreground line color (or just the line color for a solid line) |
| ForeColor | ShadowFormat | The shadow color |
| ExtrusionColor | ThreeDFormat | The color of the sides of an extruded object |
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