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
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.