CalloutFormat Properties (Excel)

Article
05/23/2016

GitHub-Mark-64px

Contribute to this content

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

Properties

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.