This topic has not yet been rated - Rate this topic

Shape.ConnectorFormat Property

Office 2007

Returns a ConnectorFormat object that contains connector formatting properties. Applies to a Shape that represent 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.

Visual Basic for Applications

Visual Basic for Applications
`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`

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

Community Additions

ADD