ShadowFormat.IncrementOffsetY method (Excel)

Changes the vertical offset of the shadow by the specified number of points. Use the OffsetY property to set the absolute vertical shadow offset.

Syntax

expression.IncrementOffsetY (Increment)

expression A variable that represents a ShadowFormat object.

Parameters

Name Required/Optional Data type Description
Increment Required Single Specifies how far the shadow offset is to be moved vertically, in points. A positive value moves the shadow down; a negative value moves it up.

Example

This example moves the shadow on shape three on myDocument up by 3 points.

Set myDocument = Worksheets(1) 
myDocument.Shapes(3).Shadow.IncrementOffsetY -3

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.