Excel.FillFormat.md

title	FillFormat object (Excel)
keywords	vbaxl10.chm115000
f1_keywords	vbaxl10.chm115000
api_name	Excel.FillFormat
ms.assetid	b602e09e-97ab-bfbe-1796-bc44ebb7dc28
ms.date	03/29/2019
ms.localizationpriority	medium

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

[!includeSupport and feedback]