ShadowFormat.IncrementOffsetX method (Excel)
Changes the horizontal offset of the shadow by the specified number of points. Use the OffsetX property to set the absolute horizontal shadow offset.
Syntax
expression.IncrementOffsetX (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 horizontally, in points. A positive value moves the shadow to the right; a negative value moves it to the left. |
Example
This example moves the shadow on shape three on myDocument to the left by 3 points.
Set myDocument = Worksheets(1)
myDocument.Shapes(3).Shadow.IncrementOffsetX -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.