Office development

CalloutFormat Properties (Excel)

GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Name

Description

Accent

Allows the user to place a vertical accent bar to separate the callout text from the callout line. Read/write MsoTriState.

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. Read/write MsoCalloutAngleType.

Application

When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.

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. Read/write MsoTriState.

AutoLength

Applies only to callouts whose lines consist of more than one segment (types msoCalloutThree and msoCalloutFour). Read/write MsoTriState.

Border

Returns or sets a MsoTriState value that represents the visibility options for the border of the object.

Creator

Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.

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. Read-only Single.

DropType

Returns a value that indicates where the callout line attaches to the callout text box. Read-only MsoCalloutDropType.

Gap

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

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

Parent

Returns the parent object for the specified object. Read-only.

Type

Returns or sets a MsoCalloutType value that represents the callout format type.

Show:
© 2016 Microsoft