AutoLength Property

Microsoft Excel Visual Basic

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

MsoTriState can be one of these MsoTriState constants.
msoCTrue
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.

Remarks

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