Excel.CalloutFormat.AutomaticLength.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
CalloutFormat.AutomaticLength method (Excel)	vbaxl10.chm104002	vbaxl10.chm104002	Excel.CalloutFormat.AutomaticLength	e82093e0-7b84-c2c8-8365-6fe05298d55b	04/13/2019	medium

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).

Syntax

expression.AutomaticLength

expression A variable that represents a CalloutFormat object.

Remarks

Applying this method sets the AutoLength property to True.

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

[!includeSupport and feedback]