EndConnected Property

Microsoft Excel Visual Basic

Show All

EndConnected Property

       

msoTrue if the end of the specified connector is connected to a shape. Read-only MsoTriState.

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