Share via

CalloutFormat.Length Property

  • Article
Excel Developer Reference

Returns a Single value that represents the length (in points) of the first segment of the callout line (the segment attached to the text callout box.)

Syntax

expression.Length

expression   A variable that represents a CalloutFormat object.

Remarks

This property is read-only and applies only to callouts whose lines consist of more than one segment (types msoCalloutThree and msoCalloutFour), and for which the AutoLength property is set to False. Use the CustomLength method to set the value of this property for a CalloutFormat object.

Example

If the first line segment in the callout named "callout1" has a fixed length, this example specifies that the length of the first line segment in the callout named "callout2" on worksheet one will also be fixed at that length. For the example to work, both callouts must have multiple-segment lines.

Visual Basic for Applications 
  Set myDocument = Worksheets(1)
With myDocument.Shapes
    With .Item("callout1").Callout
        If Not .AutoLength Then len1 = .Length
    End With
    If len1 Then .Item("callout2").Callout.CustomLength len1
End With

See Also