If you arent worried about any other list/combo boxes on your sheet, and you
dont mind downloading an Add-IN then:

http://www.asap-utilities.com/downlo...-utilities.php

Nice set of Macros and one of them has a Select/Delete all OBJECTS on
worksheet function.

There is probably a better way, but this one works too. Plus the ASAP
utility has many more useful features

"TrishB98" wrote:

I was playing with combo boxes yesterday and now there is a list box imbedded
in my spreadsheet that I cannot get rid of. Can anyone help me get rid of
this drop down??

Thanks,
Tricia