CalloutFormat.AutoLength Property (Excel)

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

Syntax

expression. AutoLength

expression A variable that represents a CalloutFormat object.

Remarks

MsoTriState can be one of these MsoTriState constants.
msoFalse . The first segment of the callout retains the fixed length specified by the Length property whenever the callout is moved.
msoTriStateMixed
msoTriStateToggle
msoTrue . The first segment of the callout line (the segment attached to the text callout box) is scaled automatically 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 mosFalse .

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

See also

CalloutFormat Object