Skip to content

Latest commit

 

History

History
52 lines (35 loc) · 1.43 KB

Excel.ConnectorFormat.BeginConnected.md

File metadata and controls

52 lines (35 loc) · 1.43 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
ConnectorFormat.BeginConnected property (Excel)
vbaxl10.chm646077
vbaxl10.chm646077
Excel.ConnectorFormat.BeginConnected
2ebc4d15-e6f3-a0c9-056e-78004465c60c
04/23/2019
medium

ConnectorFormat.BeginConnected property (Excel)

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

Syntax

expression.BeginConnected

expression A variable that represents a ConnectorFormat object.

Remarks

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

Example

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

[!includeSupport and feedback]