Edit

Share via

CalloutFormat.Angle property (Excel)

  • Article

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

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.