Excel.CalloutFormat.CustomDrop.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
CalloutFormat.CustomDrop method (Excel)	vbaxl10.chm104003	vbaxl10.chm104003	Excel.CalloutFormat.CustomDrop	d38513f6-1c42-e4b3-7a0f-b8543d59d0ff	04/13/2019	medium

CalloutFormat.CustomDrop method (Excel)

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

This distance is measured from the top of the text box unless the AutoAttach property is set to True, and the text box is to the left of the origin of the callout line (the place that the callout points to), in which case the drop distance is measured from the bottom of the text box.

Syntax

expression.CustomDrop (Drop)

expression A variable that represents a CalloutFormat object.

Parameters

Name	Required/Optional	Data type	Description
Drop	Required	Single	The drop distance, in points.

Example

This example sets the custom drop distance to 14 points, and specifies that the drop distance always be measured from the top. For the example to work, shape three must be a callout.

Set myDocument = Worksheets(1) 
With myDocument.Shapes(3).Callout 
 .CustomDrop 14 
 .AutoAttach = False 
End With

[!includeSupport and feedback]