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
"joec" wrote:
How do I insert a drop down box into a worksheet. So tht I can choose 1 item
from a list?
--
joec