Edit

Share via

CalloutFormat.AutoLength property (Excel)

  • Article

Applies only to callouts whose lines consist of more than one segment (MsoCalloutType types msoCalloutThree and msoCalloutFour). Read/write MsoTriState.

Syntax

expression.AutoLength

expression A variable that represents a CalloutFormat object.

Remarks

The first segment of the callout line (the segment attached to the text callout box) is scaled automatically whenever the callout is moved.

The first segment of the callout retains the fixed length specified by the Length property whenever the callout is moved.

This property is read-only. Use the AutomaticLength method to set this property to msoTrue, and use the CustomLength method to set this property to msoFalse.

Example

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.