How do I insert a drop down box into a worksheet. So tht I can choose 1 item from a list?
J joec Feb 28, 2009 #1 How do I insert a drop down box into a worksheet. So tht I can choose 1 item from a list?
F FSt1 Feb 28, 2009 #2 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
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
