Excel.ControlFormat.LinkedCell.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
ControlFormat.LinkedCell property (Excel)	vbaxl10.chm630079	vbaxl10.chm630079	Excel.ControlFormat.LinkedCell	398f46f0-593a-6020-6832-5aebe8c8cd68	04/23/2019	medium

ControlFormat.LinkedCell property (Excel)

Returns or sets the worksheet range linked to the control's value. If you place a value in the cell, the control takes this value. Likewise, if you change the value of the control, that value is also placed in the cell. Read/write String.

Syntax

expression.LinkedCell

expression A variable that represents a ControlFormat object.

Remarks

You cannot use this property with multiselect list boxes.

Example

This example adds a check box to worksheet one and links the check box value to cell A1.

With Worksheets(1) 
 Set cb = .Shapes.AddFormControl(xlCheckBox, 10, 10, 100, 10) 
 cb.ControlFormat.LinkedCell = "A1" 
End With

[!includeSupport and feedback]