ShadowFormat Members (Excel)

Represents shadow formatting for a shape.

Methods

Name

Description

IncrementOffsetX

Changes the horizontal offset of the shadow by the specified number of points. Use the OffsetX property to set the absolute horizontal shadow offset.

IncrementOffsetY

Changes the vertical offset of the shadow by the specified number of points. Use the OffsetY property to set the absolute vertical shadow offset.

Properties

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.

Blur

Returns or sets the degree of blurriness of the specified shadow. Read/write Single.

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.

Obscured

True if the shadow of the specified shape appears filled in and is obscured by the shape, even if the shape has no fill. False if the shadow has no fill and the outline of the shadow is visible through the shape if the shape has no fill. Read/write MsoTriState.

OffsetX

Returns or sets the horizontal offset of the shadow from the specified shape, in points. A positive value offsets the shadow to the right of the shape; a negative value offsets it to the left. Read/write Single.

OffsetY

Returns or sets the vertical offset of the shadow from the specified shape, in points. A positive value offsets the shadow to the right of the shape; a negative value offsets it to the left. Read/write Single.

Parent

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

RotateWithShape

Returns or sets an MsoTriState that represents whether to rotate the shadow when rotating the shape. Read/write.

Size

Returns or sets the size of the specified shadow. Read/write Single.

Style

Returns or sets the style of the specified shadow. Read/write MsoShadowStyle.

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 or sets a MsoShadowType value that represents the shadow format type.

Visible

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