Class FillFormat (Excel VBA)

The class FillFormat represents fill formatting for a shape.

The classes ChartFormat and Shape. give access to class FillFormat

Member in collection

Methods

OneColorGradient - Sets the specified fill to a one-color gradient.

Patterned - Sets the specified fill to a pattern.

PresetGradient - Sets the specified fill to a preset gradient.

PresetTextured - Sets the specified fill format to a preset texture.

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.

TwoColorGradient - Sets the specified fill to a two-color gradient.

UserPicture - Fills the specified shape with an image.

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

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

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.

GradientColorType returns the gradient color type for the specified fill.

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

GradientStops returns the end point for the gradient fill.

GradientStyle returns the gradient style for the specified fill.

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.

Pattern returns or sets an MsoPatternType value that represents the fill pattern.

PictureEffects returns a PictureEffects object that represents the picture or texture fill for the specified fill format.

PresetGradientType returns the preset gradient type for the specified fill.

PresetTexture returns the preset texture for the specified fill.

RotateWithObject returns or sets if the fill style should rotate with the object.

TextureAlignment returns or sets the alignment (the origin of the coordinate grid) for the tiling of the texture fill.

TextureHorizontalScale returns or sets the horizontal scaling factor for the texture fill.

TextureName returns the name of the custom texture file for the specified fill.

TextureOffsetX returns the offset X value for the specified fill.

TextureOffsetY returns the offset Y value for the specified fill.

TextureTile returns the texture tile style for the specified fill.

TextureType returns the texture type for the specified fill.

TextureVerticalScale returns the texture vertical scale for the specified fill.

Transparency returns or sets the degree of transparency of the specified fill as a value from 0.0 (opaque) through 1.0 (clear).

Type returns an MsoFillType value that represents the fill type.

Visible returns or sets an MsoTriState value that determines whether the object is visible.

ColorFormat - Represents the color of a one-color object, the foreground or background color of an object with a gradient or patterned fill, or the pointer color.