How to clear the contents of COmboBox?

[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

 

[BrianB]

something like :-
MyForm.ComboBox1.Clea

 

[Guest]

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

 

[BrianB]

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

 

[Guest]

Brian I am adding the ComboBox from the control ToolBox and I think we cannot use the Shapes/Control Format property for that.