This documentation is archived and is not being maintained.

Adjustments Interface 

Contains a collection of adjustment values for the specified AutoShape, WordArt object, or connector.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)

'Usage
Public Class djustmentsImplementation
	Implements Adjustments
End Class
Dim djustmentsImplementation1 As New djustmentsImplementation()

public interface Adjustments : _IMsoDispObj
public interface Adjustments implements _IMsoDispObj
public interface Adjustments implements _IMsoDispObj

Each adjustment value represents one way an adjustment handle can be adjusted. Because some adjustment handles can be adjusted in two ways — for instance, some handles can be adjusted both horizontally and vertically — a shape can have more adjustment values than it has adjustment handles. A shape can have up to eight adjustments.

Use the Adjustments property to return an Adjustments object. Use Adjustments(index), where index is the adjustment value’s index number, to return a single adjustment value.

Different shapes have different numbers of adjustment values, different kinds of adjustments change the geometry of a shape in different ways, and different kinds of adjustments have different ranges of valid values.

The following table summarizes the ranges of valid adjustment values for different types of adjustments. In most cases, if you specify a value that’s beyond the range of valid values, the closest valid value will be assigned to the adjustment.

Type of adjustment

Valid values

Linear (horizontal or vertical)

Generally the value 0.0 represents the left or top edge of the shape, and the value 1.0 represents the right or bottom edge of the shape. Valid values correspond to valid adjustments you can make to the shape manually. For example, if you can only pull an adjustment handle half way across the shape manually, the maximum value for the corresponding adjustment will be 0.5. For shapes such as connectors and callouts, where the values 0.0 and 1.0 represent the limits of the rectangle defined by the starting and ending points of the connector or callout line, negative numbers and numbers greater than 1.0 are valid values.

Radial

An adjustment value of 1.0 corresponds to the width of the shape. The maximum value is 0.5, or half way across the shape.

Angle

Values are expressed in degrees. If you specify a value outside the range –180 to 180, it will be normalized to be within that range.


Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

Show: