Clear Combobox
 

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

Thanks

Clear Combobox
 

Try something like

Combobox1.Clear


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com


"King" wrote in message
news:aAAib.761784$uu5.132039@sccrnsc04...
What is the quickest way to clear all entries in a combobox?

Thanks

Clear Combobox
 

Depends on how they got there. For rowsource

Combobox1.RowSource = ""

--
Regards,
Tom Ogilvy

"King" wrote in message
news:aAAib.761784$uu5.132039@sccrnsc04...
What is the quickest way to clear all entries in a combobox?

Thanks

Clear Combobox
 

This search provides a multitude of answers.

http://www.google.com/groups?as_q=Cl...n&num=50&hl=en

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------

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

Thanks