CalloutFormat object (Excel)

Contains properties and methods that apply to line callouts.

Remarks

Use the Callout property of the Shape object to return a CalloutFormat object.

Example

The following example specifies the attributes of shape three (a line callout) on myDocument:

• The callout will have a vertical accent bar that separates the text from the callout line.
• The angle between the callout line and the side of the callout text box will be 30 degrees.
• There will be no border around the callout text.
• The callout line will be attached to the top of the callout text box.
• The callout line will contain two segments.

For this example to work, shape three must be a callout.

Set myDocument = Worksheets(1) 
With myDocument.Shapes(3).Callout 
 .Accent = True 
 .Angle = msoCalloutAngle30 
 .Border = False 
 .PresetDrop msoCalloutDropTop 
 .Type = msoCalloutThree 
End With

Methods

• AutomaticLength
• CustomDrop
• CustomLength
• PresetDrop

Properties

• Accent
• Angle
• Application
• AutoAttach
• AutoLength
• Border
• Creator
• Drop
• DropType
• Gap
• Length
• Parent
• Type

See also

• Excel Object Model Reference

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.