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.

See Also

Concepts

Adjustments Object Members

Adjustments Object