CalloutFormat Members (Excel)

Contains properties and methods that apply to line callouts.

Methods

Name	Description
AutomaticLength	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 (types msoCalloutThree and msoCalloutFour).
CustomDrop	Sets the vertical distance (in points) from the edge of the text bounding box to the place where the callout line attaches to the text box. This distance is measured from the top of the text box unless the AutoAttach property is set to True and the text box is to the left of the origin of the callout line (the place that the callout points to), in which case the drop distance is measured from the bottom of the text box.
CustomLength	Specifies that the first segment of the callout line (the segment attached to the text callout box) retain a fixed length whenever the callout is moved. Use the AutomaticLength method to specify that the first segment of the callout line be scaled automatically whenever the callout is moved. Applies only to callouts whose lines consist of more than one segment (types msoCalloutThree and msoCalloutFour).
PresetDrop	Specifies whether the callout line attaches to the top, bottom, or center of the callout text box or whether it attaches at a point that’s a specified distance from the top or bottom of the text box.

Properties

Name	Description
Accent	Allows the user to place a vertical accent bar to separate the callout text from the callout line. Read/write MsoTriState.
Angle	Returns or sets the angle of the callout line. If the callout line contains more than one line segment, this property returns or sets the angle of the segment that is farthest from the callout text box. Read/write MsoCalloutAngleType.
Application	When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
AutoAttach	True if the place where the callout line attaches to the callout text box changes depending on whether the origin of the callout line (where the callout points to) is to the left or right of the callout text box. Read/write MsoTriState.
AutoLength	Applies only to callouts whose lines consist of more than one segment (types msoCalloutThree and msoCalloutFour). Read/write MsoTriState.
Border	Returns or sets a MsoTriState value that represents the visibility options for the border of the object.
Creator	Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.
Drop	For callouts with an explicitly set drop value, this property returns the vertical distance (in points) from the edge of the text bounding box to the place where the callout line attaches to the text box. Read-only Single.
DropType	Returns a value that indicates where the callout line attaches to the callout text box. Read-only MsoCalloutDropType.
Gap	Returns or sets the horizontal distance (in points) between the end of the callout line and the text bounding box. Read/write Single.
Length	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.)
Parent	Returns the parent object for the specified object. Read-only.
Type	Returns or sets a MsoCalloutType value that represents the callout format type.