Angle Property

Microsoft Excel Visual Basic

MsoCalloutAngleType can be one of these MsoCalloutAngleType constants.
msoCalloutAngle30
msoCalloutAngle45
msoCalloutAngle60
msoCalloutAngle90
msoCalloutAngleAutomatic
msoCalloutAngleMixed

expression.Angle

expression    Required. An expression that returns one of the objects in the Applies To list.

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