Thread: drop down box
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default drop down box

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