Excel.CalloutFormat.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
CalloutFormat object (Excel)	vbaxl10.chm104000	vbaxl10.chm104000	Excel.CalloutFormat	d9d7d279-04ef-dbee-23cd-ddd606ed917d	03/29/2019	medium

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

[!includeSupport and feedback]