Clear Combobox

[King]

What is the quickest way to clear all entries in a combobox?

Thanks

 

[Chip Pearson]

Try something like

Combobox1.Clear

 

[Tom Ogilvy]

Depends on how they got there. For rowsource

Combobox1.RowSource = ""

 

[pfsardella]

This search provides a multitude of answers.

http://www.google.com/groups?as_q=C...F-8&as_ugroup=*excel*&lr=lang_en&num=50&hl=en

HTH
Paul