drop down box

[joec]

How do I insert a drop down box into a worksheet. So tht I can choose 1 item
from a list?

 

[FSt1]

hi
the easiest way would be data validation. see this sites for some how to
stuff.
http://www.contextures.com/xlDataVal01.html
http://www.contextures.com/xlDataVal02.html

another way would be to use a combo box from the controls toolbox. see this
site.
http://www.contextures.com/xlDataVal02.html

the above site is technically 1 site, just different tips. nice site. well
worth the time spent reading over.

Regards
FSt1