Applies To
CheckBox Object, DrawingObjects Collection, DropDown Object, DropDowns Collection, ListBox Object, ListBoxes Collection, OptionButton Object, OptionButtons Collection, ScrollBar Object, ScrollBars Collection, Spinner Object, Spinners Collection.
Description
Returns or sets the cell or cells (as a string reference) linked to the control's value. When a value is placed in the cell, the control takes this value. Likewise, if the value of the control changes, that value is also placed in the cell.
Remarks
This property cannot be used with multi-select list boxes.
Example
This example sets the fill range and the cell link for list box one on Sheet1.
Worksheets("Sheet1").ListBoxes(1).ListFillRange = "Sheet1!A1:A8"
Worksheets("Sheet1").ListBoxes(1).LinkedCell = "Sheet1!B1"