FillFormat Object [Excel 2003 VBA Language Reference]
Multiple objects FillFormat ColorFormat |
Represents fill formatting for a shape. A shape can have a solid, gradient, texture, pattern, picture, or semi-transparent fill.
Using the FillFormat Object
Use the Fill property to return a FillFormat object. The following example adds a rectangle to myDocument
and then sets the gradient and color for the rectangle's fill.
Set myDocument = Worksheets(1)
With myDocument.Shapes.AddShape(msoShapeRectangle, _
90, 90, 90, 80).Fill
.ForeColor.RGB = RGB(0, 128, 128)
.OneColorGradient msoGradientHorizontal, 1, 1
End With
Remarks
Many of the properties of the FillFormat object are read-only. To set one of these properties, you have to apply the corresponding method.
Properties | Application Property | BackColor Property | Creator Property | ForeColor Property | GradientColorType Property | GradientDegree Property | GradientStyle Property | GradientVariant Property | Parent Property | Pattern Property | PresetGradientType Property | PresetTexture Property | TextureName Property | TextureType Property | Transparency Property | Type Property | Visible Property
Methods | OneColorGradient Method | Patterned Method | PresetGradient Method | PresetTextured Method | Solid Method | TwoColorGradient Method | UserPicture Method | UserTextured Method
Parent Objects | Shape Object | ShapeRange Collection
Child Objects | ColorFormat Object