LinkCell Property
 

I have built a worksheet which has a couple of Combobox on it, which are
populated from a named ranges. Each of the comboboxes has it's LinkedCell
property set at design time.

However I wish to change each Comboboxes' LinkCell property at run-time.

[Combobox name].LinkedCell = "" - seems to break the connection

[Combobox name].LinkedCell = "Sheet1!A1" - does not reset it.

How do I reference the new LinkedCell to update that property of the
Combobox?

EA

LinkCell Property
 

Activesheet.[Combobox name].LinkedCell = "Sheet1!A1"

worked for me (in XL2003)!

Regards,
Stefi

€žEA€� ezt Ã*rta:

I have built a worksheet which has a couple of Combobox on it, which are
populated from a named ranges. Each of the comboboxes has it's LinkedCell
property set at design time.

However I wish to change each Comboboxes' LinkCell property at run-time.

[Combobox name].LinkedCell = "" - seems to break the connection

[Combobox name].LinkedCell = "Sheet1!A1" - does not reset it.

How do I reference the new LinkedCell to update that property of the
Combobox?

EA