EndConnected Property

Microsoft Excel Visual Basic

MsoTriState can be one of these MsoTriState constants.
msoCTrue Does not apply to this property.
msoFalse The end of the specified connector is not connected to a shape.
msoTriStateMixed Does not apply to this property.
msoTriStateToggle Does not apply to this property.
msoTrue The end of the specified connector is connected to a shape.

expression.EndConnected

expression    Required. An expression that returns one of the objects in the Applies To list.

Example

If the end of the connector represented by shape three on myDocument is connected to a shape, this example stores the connection site number in the variable oldEndConnSite, stores a reference to the connected shape in the object variable oldEndConnShape, and then disconnects the end of the connector from the shape.

Set myDocument = Worksheets(1)
With myDocument.Shapes(3)
    If .Connector Then
        With .ConnectorFormat
            If .EndConnected Then
                oldEndConnSite = .EndConnectionSite
                Set oldEndConnShape = .EndConnectedShape
                .EndDisconnect
            End If
        End With
    End If
End With