ShadowFormat object (Excel)

Represents shadow formatting for a shape.

Remarks

Use the Shadow property of the Shape object to return a ShadowFormat object.

Example

The following example adds a shadowed rectangle to myDocument. The semi-transparent, 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

Methods

• IncrementOffsetX
• IncrementOffsetY

Properties

• Application
• Blur
• Creator
• ForeColor
• Obscured
• OffsetX
• OffsetY
• Parent
• RotateWithShape
• Size
• Style
• Transparency
• Type
• Visible

See also

• Excel Object Model Reference

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.