| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Invalid Property" msg when Property Valid??? | Excel Programming | |||
| Runtime Error 380 – Could not set the list property. Invalid property value | Excel Programming | |||
| Value Property vs Text property | Excel Programming | |||
| Runtime error 380: Could not set the List property. invalid property value of listbox | Excel Programming | |||
| Is there a Filename property in PrintOut property | Excel Programming | |||
Linear Mode
