Share via


ConnectorFormat.EndConnected Property (Excel)

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

Syntax

expression .EndConnected

expression A variable that represents a ConnectorFormat object.

Remarks

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.

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

See Also

Concepts

ConnectorFormat Object Members

ConnectorFormat Object