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 of the Shape object 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

Methods

• OneColorGradient
• Patterned
• PresetGradient
• PresetTextured
• Solid
• TwoColorGradient
• UserPicture
• UserTextured

Properties

• Application
• BackColor
• Creator
• ForeColor
• GradientAngle
• GradientColorType
• GradientDegree
• GradientStops
• GradientStyle
• GradientVariant
• Parent
• Pattern
• PictureEffects
• PresetGradientType
• PresetTexture
• RotateWithObject
• TextureAlignment
• TextureHorizontalScale
• TextureName
• TextureOffsetX
• TextureOffsetY
• TextureTile
• TextureType
• TextureVerticalScale
• Transparency
• Type
• Visible

See also

• Excel Object Model Reference

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.