Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

LinkedCell Property [Excel 2003 VBA Language Reference]

Office 2003

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.

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
		




Show:
© 2015 Microsoft