Class ShadowFormat (Excel VBA)
The class ShadowFormat represents shadow formatting for a shape.
Properties
Blur returns or sets the degree of blurriness of the specified shadow.
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.
Set myDocument = Worksheets(1)
With myDocument.Shapes(3).Shadow
.Visible = True
.OffsetX = 5
.OffsetY = -3
.Obscured = msoTrue
End With
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.
Set myDocument = Worksheets(1)
With myDocument.Shapes(3).Shadow
.Visible = True
.OffsetX = 5
.OffsetY = -3
End With
OffsetY returns or sets the vertical offset of the shadow from the specified shape, in points. A positive value offsets the shadow down; a negative value offsets it up.
Set myDocument = Worksheets(1)
With myDocument.Shapes(3).Shadow
.Visible = True
.OffsetX = 5
.OffsetY = -3
End With
Parent returns the parent object for the specified object. Read-only.
RotateWithShape returns or sets an MsoTriState value that represents whether to rotate the shadow when rotating the shape.
Size returns or sets the size of the specified shadow.
Style returns or sets the style of the specified shadow.
Transparency returns or sets the degree of transparency of the specified fill as a value from 0.0 (opaque) through 1.0 (clear).
With Worksheets(1).Shapes(3).Shadow
.Visible = True
.ForeColor.RGB = RGB(255, 0, 0)
.Transparency = 0.5
End With
Type returns or sets an MsoShadowType value that represents the shadow format type.
Visible returns or sets an MsoTriState value that determines whether the object is visible.