Skip to content

Latest commit

 

History

History
47 lines (32 loc) · 1.17 KB

Excel.ShapeRange.Callout.md

File metadata and controls

47 lines (32 loc) · 1.17 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
ShapeRange.Callout property (Excel)
vbaxl10.chm640099
vbaxl10.chm640099
Excel.ShapeRange.Callout
15078411-7968-27ba-aa73-2c5d69220b08
05/14/2019
medium

ShapeRange.Callout property (Excel)

Returns a CalloutFormat object that contains callout formatting properties for the specified shape. Applies to ShapeRange objects that represent line callouts. Read-only.

Syntax

expression.Callout

expression A variable that represents a ShapeRange object.

Example

This example adds to myDocument an oval and a callout that points to the oval. The callout text won't have a border, but it will have a vertical accent bar that separates the text from the callout line.

Set myDocument = Worksheets(1) 
With myDocument.Shapes 
 .AddShape msoShapeOval, 180, 200, 280, 130 
 With .AddCallout(msoCalloutTwo, 420, 170, 170, 40) 
 .TextFrame.Characters.Text = "My oval" 
 With .Callout 
 .Accent = True 
 .Border = False 
 End With 
 End With 
End With

[!includeSupport and feedback]