drop down box

joec · Feb 28, 2009

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

FSt1 · Feb 28, 2009

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

Vlookup v. drop down box for mailing addresses	1	Sep 8, 2009
customize drop-down box	1	Mar 10, 2010
drop down box code	2	Sep 29, 2013
Drop Down with dynamic named range offsheet source list	14	May 22, 2014
drop down data want to choose more than one item for cell	1	Feb 26, 2010
Drop down box issue	2	Feb 10, 2010
Dependent drop down dynamic range formula, off sheet.	7	Dec 19, 2014
Populating Data From Drop-Down Item	1	Jun 16, 2009

Ask a Question