ShadowFormat Object

Remarks

Use the Shadow property to return a ShadowFormat object.

Example

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

See also:

• Excel Object Model Reference
• ShadowFormat Object Members