FillFormat Properties (Excel)

GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Name

Description

Application

When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.

BackColor

Returns or sets a ColorFormat object that represents the specified fill background color.

Creator

Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.

ForeColor

Returns or sets a ColorFormat object that represents the specified foreground fill or solid color.

GradientAngle

Returns or sets the angle of the gradient fill for the specified fill format. Read/write

GradientColorType

Returns the gradient color type for the specified fill. Read-only MsoGradientColorType.

GradientDegree

Returns the gradient degree of the specified one-color shaded fill as a floating-point value from 0.0 (dark) through 1.0 (light). Read-only Single.

GradientStops

Returns the end point for the gradient fill. Read-only.

GradientStyle

Returns the gradient style for the specified fill. Read-only MsoGradientStyle.

GradientVariant

Returns the shade variant for the specified fill as an integer value from 1 through 4. The values for this property correspond to the gradient variants (numbered from left to right and from top to bottom) on the Gradient tab in the Fill Effects dialog box. Read-only Long

Parent

Returns the parent object for the specified object. Read-only.

Pattern

Returns or sets an MsoPatternType value that represents the fill pattern.

PictureEffects

Returns an object that represents the picture or texture fill for the specified fill format. Read-only

PresetGradientType

Returns the preset gradient type for the specified fill. Read-only MsoPresetGradientType.

PresetTexture

Returns the preset texture for the specified fill. Read-only MsoPresetTexture.

RotateWithObject

Returns or sets if the fill style should rotate with the object. Read/write MsoTriState.

TextureAlignment

Returns or sets the text alignment for the specified FillFormat object. Read/write.

TextureHorizontalScale

Returns or sets the value for horizontally scaling the text for the FillFormat object. Read/write Single.

TextureName

Returns the name of the custom texture file for the specified fill. Read-only String.

TextureOffsetX

Returns the offset X value for the specified fill. Read/write Single.

TextureOffsetY

Returns the offset Y value for the specified fill. Read/write Single.

TextureTile

Returns the texture tile style for the specified fill. Read/write MsoTriState.

TextureType

Returns the texture type for the specified fill. Read-only MsoTextureType.

TextureVerticalScale

Returns the texture vertical scale for the specified fill. Read/write Single.

Transparency

Returns or sets the degree of transparency of the specified fill as a value from 0.0 (opaque) through 1.0 (clear). Read/write Double.

Type

Returns a MsoFillType value that represents the fill type.

Visible

Returns or sets a MsoTriState value that determines whether the object is visible. Read/write.

Show: