Adjustments.Item property (Excel)

Returns or sets the adjustment value specified by the Index argument. Read/write Single.

Syntax

expression.Item (Index)

expression A variable that represents an Adjustments object.

Parameters

Name Required/Optional Data type Description
Index Required [INT] Long. The index number of the adjustment.

Remarks

AutoShapes, connectors, and WordArt objects can have up to eight adjustments.

For linear adjustments, an adjustment value of 0.0 generally corresponds to the left or top edge of the shape, and a value of 1.0 generally corresponds to the right or bottom edge of the shape. However, adjustments can pass beyond shape boundaries for some shapes.

For radial adjustments, an adjustment value of 1.0 corresponds to the width of the shape.

For angular adjustments, the adjustment value is specified in degrees. The Item property applies only to shapes that have adjustments.

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.