E
EA
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
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