FillFormat Object Members

  • Article
Excel Developer Reference

Represents fill formatting for a shape.

Methods

  Name Description
Bb242246.methods(en-us,office.12).gif OneColorGradient Sets the specified fill to a one-color gradient.
Bb242246.methods(en-us,office.12).gif Patterned Sets the specified fill to a pattern.
Bb242246.methods(en-us,office.12).gif PresetGradient Sets the specified fill to a preset gradient.
Bb242246.methods(en-us,office.12).gif PresetTextured Sets the specified fill format to a preset texture.
Bb242246.methods(en-us,office.12).gif Solid Sets the specified fill to a uniform color. Use this method to convert a gradient, textured, patterned, or background fill back to a solid fill.
Bb242246.methods(en-us,office.12).gif TwoColorGradient Sets the specified fill to a two-color gradient.
Bb242246.methods(en-us,office.12).gif UserPicture Fills the specified shape with an image.
Bb242246.methods(en-us,office.12).gif UserTextured Fills the specified shape with small tiles of an image. If you want to fill the shape with one large image, use the UserPicture method.

Properties

  Name Description
Bb242246.properties(en-us,office.12).gif 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.
Bb242246.properties(en-us,office.12).gif BackColor Returns or sets a ColorFormat object that represents the specified fill background color.
Bb242246.properties(en-us,office.12).gif Creator Returns a 32-bit integer that indicates the application in which this object was created. If the object was created in Microsoft Excel, this property returns the string XCEL, which is equivalent to the hexadecimal number 5843454C.
Bb242246.properties(en-us,office.12).gif ForeColor Returns or sets a ColorFormat object that represents the specified foreground fill or solid color.
Bb242246.properties(en-us,office.12).gif GradientColorType Returns the gradient color type for the specified fill. Read-only MsoGradientColorType.
Bb242246.properties(en-us,office.12).gif 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.
Bb242246.properties(en-us,office.12).gif GradientStops Read-only
Bb242246.properties(en-us,office.12).gif GradientStyle Returns the gradient style for the specified fill. Read-only MsoGradientStyle.
Bb242246.properties(en-us,office.12).gif 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
Bb242246.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb242246.properties(en-us,office.12).gif Pattern Returns or sets an MsoPatternType value that represents the fill pattern.
Bb242246.properties(en-us,office.12).gif PresetGradientType Returns the preset gradient type for the specified fill. Read-only MsoPresetGradientType.
Bb242246.properties(en-us,office.12).gif PresetTexture Returns the preset texture for the specified fill. Read-only MsoPresetTexture.
Bb242246.properties(en-us,office.12).gif RotateWithObject Read/write
Bb242246.properties(en-us,office.12).gif TextureAlignment Read/write
Bb242246.properties(en-us,office.12).gif TextureHorizontalScale Read/write
Bb242246.properties(en-us,office.12).gif TextureName Returns the name of the custom texture file for the specified fill. Read-only String.
Bb242246.properties(en-us,office.12).gif TextureOffsetX Read/write
Bb242246.properties(en-us,office.12).gif TextureOffsetY Read/write
Bb242246.properties(en-us,office.12).gif TextureTile Read/write
Bb242246.properties(en-us,office.12).gif TextureType Returns the texture type for the specified fill. Read-only MsoTextureType.
Bb242246.properties(en-us,office.12).gif TextureVerticalScale Read/write
Bb242246.properties(en-us,office.12).gif 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.
Bb242246.properties(en-us,office.12).gif Type Returns a MsoFillType value that represents the the fill type.
Bb242246.properties(en-us,office.12).gif Visible Returns or sets a MsoTriState value that determines whether the object is visible. Read/write.