ShadowFormat Object [Excel 2003 VBA Language Reference]
Multiple objects ShadowFormat ColorFormat |
Represents shadow formatting for a shape.
Using the ShadowFormat Object
Use the Shadow property to return a ShadowFormat object. The following example adds a shadowed rectangle to myDocument
. The semitransparent, blue shadow is offset 5 points to the right of the rectangle and 3 points above it.
Set myDocument = Worksheets(1)
With myDocument.Shapes.AddShape(msoShapeRectangle, _
50, 50, 100, 200).Shadow
.ForeColor.RGB = RGB(0, 0, 128)
.OffsetX = 5
.OffsetY = -3
.Transparency = 0.5
.Visible = True
End With
Properties | Application Property | Creator Property | ForeColor Property | Obscured Property | OffsetX Property | OffsetY Property | Parent Property | Transparency Property | Type Property | Visible Property
Methods | IncrementOffsetX Method | IncrementOffsetY Method
Parent Objects | Shape Object | ShapeRange Collection
Child Objects | ColorFormat Object