Share via


FillFormat Object (Excel)

Represents fill formatting for a shape.

Remarks

A shape can have a solid, gradient, texture, pattern, picture, or semi-transparent fill.

Many of the properties of the FillFormat object are read-only. To set one of these properties, you have to apply the corresponding method.

Example

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

See Also

Concepts

Excel Object Model Reference

FillFormat Object Members