CalloutFormat.Gap property (Excel)

Returns or sets the horizontal distance (in points) between the end of the callout line and the text bounding box. Read/write Single.

Syntax

expression.Gap

expression A variable that represents a CalloutFormat object.

Example

This example sets the distance between the callout line and the text bounding box to 3 points for shape one on myDocument. For the example to work, shape one must be a callout.

Set myDocument = Worksheets(1) 
myDocument.Shapes(1).Callout.Gap = 3

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.