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 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
- OneColorGradient
- Patterned
- PresetGradient
- PresetTextured
- Solid
- TwoColorGradient
- UserPicture
- UserTextured
- 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
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.