This topic has not yet been rated - Rate this topic

ShadowFormat Object

Office 2007

Represents shadow formatting for a shape.

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.

Visual Basic for Applications

Visual Basic for Applications
`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`

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

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ