C
caroline
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
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