Class CalloutFormat (Excel VBA)

Contains properties and methods that apply to line callouts.

Class Shape gives access to class CalloutFormat.

Methods

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.

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.

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.

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

Accent allows the user to place a vertical accent bar to separate the callout text from the callout line.

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.

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.

AutoLength applies only to callouts whose lines consist of more than one segment (MsoCalloutType types msoCalloutThree and msoCalloutFour).

Border returns or sets an MsoTriState value that represents the visibility options for the border of the object.

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.

DropType returns a value that indicates where the callout line attaches to the callout text box.

Gap returns or sets the horizontal distance (in points) between the end of the callout line and the text bounding box.

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

Type returns or sets an MsoCalloutType value that represents the callout format type.