Removing a listbox from excel spreadsheet

  • Thread starter Thread starter TrishB98
  • Start date Start date
T

TrishB98

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
 
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/download-asap-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
 
And just to make sure....
If you havent already tried, right click on your toolbar and activate the
Control Toolbox toolbar.
THen click on the first button to put yourself in design mode...
you should then be able to select any combo/list boxes and simply delete them.
 
thanks...that suggestion was very helpful!


SJAdams4444 said:
And just to make sure....
If you havent already tried, right click on your toolbar and activate the
Control Toolbox toolbar.
THen click on the first button to put yourself in design mode...
you should then be able to select any combo/list boxes and simply delete them.
Click to expand...
 
Back
Top