CalloutFormat Object [Excel 2003 VBA Language Reference]

Multiple objects

Contains properties and methods that apply to line callouts.

Using the CalloutFormat Object

Use the Callout property to return a CalloutFormat object. The following example specifies the following 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; and 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

Properties | Accent Property | Angle Property | Application Property | AutoAttach Property | AutoLength Property | Border Property | Creator Property | Drop Property | DropType Property | Gap Property | Length Property | Parent Property | Type Property

Methods | AutomaticLength Method | CustomDrop Method | CustomLength Method | PresetDrop Method

Parent Objects | Shape Object | ShapeRange Collection

Child Objects