Skip to content

Files

Latest commit

 

History

History
47 lines (33 loc) · 1.27 KB

Excel.Shape.ConnectorFormat.md

File metadata and controls

47 lines (33 loc) · 1.27 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Shape.ConnectorFormat property (Excel)
vbaxl10.chm636095
vbaxl10.chm636095
Excel.Shape.ConnectorFormat
4c000a5c-eed2-e93c-e801-999c96750c9e
05/14/2019
medium

Shape.ConnectorFormat property (Excel)

Returns a ConnectorFormat object that contains connector formatting properties. Applies to a Shape object that represents connectors. Read-only.

Syntax

expression.ConnectorFormat

expression An expression that returns a Shape object.

Example

This example adds two rectangles to myDocument, attaches them with a connector, automatically reroutes the connector along the shortest path, and then detaches the connector from the rectangles.

Set myDocument = Worksheets(1) 
Set s = myDocument.Shapes 
Set firstRect = s.AddShape(msoShapeRectangle, 100, 50, 200, 100) 
Set secondRect = s.AddShape(msoShapeRectangle, 300, 300, 200, 100) 
Set c = s.AddConnector(msoConnectorCurve, 0, 0, 0, 0) 
with c.ConnectorFormat 
 .BeginConnect firstRect, 1 
 .EndConnect secondRect, 1 
 c.RerouteConnections 
 .BeginDisconnect 
 .EndDisconnect 
End With

[!includeSupport and feedback]