CalloutFormat.Angle Property (Excel)

Returns or sets the angle of the callout line. If the callout line contains more than one line segment, this property returns or sets the angle of the segment that is farthest from the callout text box. Read/write MsoCalloutAngleType.

Syntax

expression .Angle

expression A variable that represents a CalloutFormat object.

Remarks

If you set the value of this property to anything other than msoCalloutAngleAutomatic, the callout line maintains a fixed angle as you drag the callout.

Example

This example sets to 90 degrees the callout angle for a callout named "callout1" on myDocument.

Set myDocument = Worksheets(1) 
myDocument.Shapes("callout1").Callout.Angle = msoCalloutAngle90

See Also

Concepts

CalloutFormat Object Members

CalloutFormat Object