Skip to content

Latest commit

 

History

History
47 lines (32 loc) · 1.15 KB

Excel.Shape.Callout.md

File metadata and controls

47 lines (32 loc) · 1.15 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Shape.Callout property (Excel)
vbaxl10.chm636092
vbaxl10.chm636092
Excel.Shape.Callout
80c67ea9-7e55-9841-bbed-302cbd669ce5
05/14/2019
medium

Shape.Callout property (Excel)

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

Syntax

expression.Callout

expression A variable that represents a Shape 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]