Skip to content

Latest commit

 

History

History
66 lines (49 loc) · 1.74 KB

Excel.ShadowFormat.md

File metadata and controls

66 lines (49 loc) · 1.74 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
ShadowFormat object (Excel)
vbaxl10.chm114000
vbaxl10.chm114000
Excel.ShadowFormat
2566c68e-f8d6-badc-3ce9-b6ae5f9c1cc2
04/02/2019
medium

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

Properties

See also

[!includeSupport and feedback]