FillFormat Object

Description

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.