FillFormat Object (Excel)
Collapse the table of content
Expand the table of content
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer

FillFormat Object (Excel)

Represents fill formatting for a shape.

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.

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
© 2015 Microsoft