CalloutFormat.AutomaticLength method (Excel)
Specifies that the first segment of the callout line (the segment attached to the text callout box) be scaled automatically when the callout is moved.
Use the CustomLength method to specify that the first segment of the callout line retain the fixed length returned by the Length property whenever the callout is moved. Applies only to callouts whose lines consist of more than one segment (MsoCalloutType types msoCalloutThree and msoCalloutFour).
expression A variable that represents a CalloutFormat object.
Applying this method sets the AutoLength property to True.
This example toggles between an automatically scaling first segment and one with a fixed length for the callout line for shape one on myDocument. For the example to work, shape one must be a callout.
Set myDocument = Worksheets(1) With myDocument.Shapes(1).Callout If .AutoLength Then .CustomLength 50 Else .AutomaticLength End If End With
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.