Share via


CalloutFormat Object Members

Excel Developer Reference

Contains properties and methods that apply to line callouts.

Methods

  Name Description
Bb255877.methods(en-us,office.12).gif 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).
Bb255877.methods(en-us,office.12).gif 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.
Bb255877.methods(en-us,office.12).gif 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).
Bb255877.methods(en-us,office.12).gif 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
Bb255877.properties(en-us,office.12).gif Accent Allows the user to place a vertical accent bar to separate the callout text from the callout line. Read/write MsoTriState.
Bb255877.properties(en-us,office.12).gif 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.
Bb255877.properties(en-us,office.12).gif 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.
Bb255877.properties(en-us,office.12).gif 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.
Bb255877.properties(en-us,office.12).gif AutoLength Applies only to callouts whose lines consist of more than one segment (types msoCalloutThree and msoCalloutFour). Read/write MsoTriState.
Bb255877.properties(en-us,office.12).gif Border Returns or sets a MsoTriState value that represents the visibility options for the border of the object.
Bb255877.properties(en-us,office.12).gif Creator Returns a 32-bit integer that indicates the application in which this object was created. If the object was created in Microsoft Excel, this property returns the string XCEL, which is equivalent to the hexadecimal number 5843454C.
Bb255877.properties(en-us,office.12).gif 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.
Bb255877.properties(en-us,office.12).gif DropType Returns a value that indicates where the callout line attaches to the callout text box. Read-only MsoCalloutDropType.
Bb255877.properties(en-us,office.12).gif Gap Returns or sets the horizontal distance (in points) between the end of the callout line and the text bounding box. Read/write Single.
Bb255877.properties(en-us,office.12).gif 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.)
Bb255877.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb255877.properties(en-us,office.12).gif Type Returns or sets a MsoCalloutType value that represents the callout format type.