Excel.CalloutFormat.PresetDrop.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
CalloutFormat.PresetDrop method (Excel)	vbaxl10.chm104005	vbaxl10.chm104005	Excel.CalloutFormat.PresetDrop	48d67cad-d93b-2b69-35dd-c3de70340a42	04/13/2019	medium

CalloutFormat.PresetDrop method (Excel)

Specifies whether the callout line attaches to the top, bottom, or center of the callout text box, or whether it attaches at a point that's a specified distance from the top or bottom of the text box.

Syntax

expression.PresetDrop (DropType)

expression A variable that represents a CalloutFormat object.

Parameters

Name	Required/Optional	Data type	Description
DropType	Required	MsoCalloutDropType	The starting position of the callout line relative to the text bounding box.

Example

This example specifies that the callout line attach to the top of the text bounding box for shape one on myDocument. For the example to work, shape one must be a callout.

Set myDocument = Worksheets(1) 
myDocument.Shapes(1).Callout.PresetDrop msoCalloutDropTop

This example toggles between two preset drops for shape one on myDocument. For the example to work, shape one must be a callout.

Set myDocument = Worksheets(1) 
With myDocument.Shapes(1).Callout 
    If .DropType = msoCalloutDropTop Then 
        .PresetDrop msoCalloutDropBottom 
    ElseIf .DropType = msoCalloutDropBottom Then 
        .PresetDrop msoCalloutDropTop 
    End If 
End With

[!includeSupport and feedback]