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