Skip to content

Latest commit

 

History

History
50 lines (31 loc) · 1.65 KB

Excel.CalloutFormat.Length.md

File metadata and controls

50 lines (31 loc) · 1.65 KB
Raw
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
CalloutFormat.Length property (Excel)
vbaxl10.chm104014
vbaxl10.chm104014
Excel.CalloutFormat.Length
e17dacaa-f48f-8802-3912-f84a0e4dd8ca
04/13/2019
medium

CalloutFormat.Length property (Excel)

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 (MsoCalloutType 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.

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

[!includeSupport and feedback]