Skip to content

Latest commit

 

History

History
45 lines (26 loc) · 1.32 KB

Excel.Adjustments.Item.md

File metadata and controls

45 lines (26 loc) · 1.32 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Adjustments.Item property (Excel)
vbaxl10.chm103003
vbaxl10.chm103003
Excel.Adjustments.Item
b3f3a20c-3ef0-48be-411a-dfb08758684d
04/04/2019
medium

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.

[!includeSupport and feedback]