ConnectorFormat.BeginConnected Property (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

True if the beginning of the specified connector is connected to a shape. Read-only MsoTriState.

expression .BeginConnected

expression A variable that represents a ConnectorFormat object.

MsoTriState can be one of these MsoTriState constants.

msoCTrue

msoFalse

msoTriStateMixed

msoTriStateToggle

msoTrue. The beginning of the specified connector is connected to a shape.

If shape three on myDocument is a connector whose beginning is connected to a shape, this example stores the connection site number in the variable oldBeginConnSite, stores a reference to the connected shape in the object variable oldBeginConnShape, and then disconnects the beginning of the connector from the shape.

Set myDocument = Worksheets(1) 
With myDocument.Shapes(3) 
    If .Connector Then 
        With .ConnectorFormat 
            If .BeginConnected Then 
                oldBeginConnSite = .BeginConnectionSite 
                Set oldBeginConnShape = .BeginConnectedShape 
                .BeginDisconnect 
            End If 
        End With 
    End If 
End With
Show: