How to clear the contents of COmboBox?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I have combobox to which I add options on first itireation by Additem property. On next iteration, the old values shoudl be cleared but I cannot use Clear method, its giving error.
I later found that Clear method fails for comboboxes created at design time. Now on second iteration , although new values are added but values form previous additon remain( which are totally irrelevant in new context)
How do I clear the previous options of dropdownlist associated with the combobox
TI
Shilps
 
Thanks Brian, but I have already stated that I am not able to stand Clear method as it is giving error. And the Combobox is on the worksheet , not on a form
 
I think you may need to copy/paste your setup code so we can see whic
control you are using.

Perhaps this is what you want, although it is a DropDown :-

Set MyDropDown = ActiveSheet.Shapes("Drop Down1")
MyDropDown.ControlFormat.RemoveAllItem
 
Brian I am adding the ComboBox from the control ToolBox and I think we cannot use the Shapes/Control Format property for that.
 
Back
Top