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.