| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox
I have a combobox on a sheet and I want to update its list with non numerical
values organised on another sheet in a row. THIS WORKS: ActiveSheet.OLEObjects("Combobox1").ListFillRange = Range("SubRegion1").Address BUT THIS DOES NOT WORK ActiveSheet.OLEObjects("Combobox1").ListFillRange = Range("SubRegion1").Address Set myrange = Sheets("Define Regions").Range("SubRegionsList") For Each c In myrange ActiveSheet.OLEObjects("Combobox1").AddItem c.Value Next THE ERROR is 435 (object does not support this property method Combobox1.AddItem c.Value does not work either Any idea? I call the sub when I activate the sheet Any help greatly appreciated -- caroline |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
| Combobox items determined by the selection in another combobox | Excel Programming | |||
| Combobox options based on the input of another combobox | Excel Programming | |||
| ComboBox list reliant on the entry from a different ComboBox | Excel Programming | |||
| How Do I Load A ComboBox RowSource From The Results Of Another ComboBox | Excel Programming | |||
Threaded Mode
