Muokkaa

Jaa

ConnectorFormat.EndConnected property (Excel)

  • Artikkeli

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.

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.