ShadowFormat Properties (Excel)

GitHub-Mark-64px

Contribute to this content

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

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.