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 |
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.