ConnectorFormat.EndConnect method (Excel)
Attaches the end of the specified connector to a specified shape. If there's already a connection between the end of the connector and another shape, that connection is broken.
If the end of the connector isn't already positioned at the specified connecting site, this method moves the end of the connector to the connecting site and adjusts the size and position of the connector.
Use the BeginConnect method to attach the beginning of the connector to a shape.
Syntax
expression.EndConnect (ConnectedShape, ConnectionSite)
expression A variable that represents a ConnectorFormat object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| ConnectedShape | Required | Shape | The shape to attach the end of the connector to. The specified Shape object must be in the same Shapes collection as the connector. |
| ConnectionSite | Required | Long | Must be an integer between 1 and the integer returned by the ConnectionSiteCount property of the specified shape. If you want the connector to automatically find the shortest path between the two shapes it connects, specify any valid integer for this argument and then use the RerouteConnections method after the connector is attached to shapes at both ends. |
Remarks
When you attach a connector to an object, the size and position of the connector are automatically adjusted, if necessary.
Example
This example adds two rectangles to myDocument and connects them with a curved connector. Notice that the RerouteConnections method makes it irrelevant what values you supply for the ConnectionSite arguments used with the BeginConnect and EndConnect methods.
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, 100, 100)
With c.ConnectorFormat
.BeginConnect ConnectedShape:=firstRect, ConnectionSite:=1
.EndConnect ConnectedShape:=secondRect, ConnectionSite:=1
c.RerouteConnections
End With
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.