M Mai Sep 4, 2003 #1 I need to make several drop down boxs in my worksheet, but don't know how, can anyone give me direction on how to do this?
I need to make several drop down boxs in my worksheet, but don't know how, can anyone give me direction on how to do this?
R Ron de Bruin Sep 4, 2003 #2 See Debra's site first and post back if you need something else http://www.contextures.com/xlDataVal01.html
See Debra's site first and post back if you need something else http://www.contextures.com/xlDataVal01.html
K Kathy Sep 4, 2003 #3 Select View Tool Bars Select Forms toolbar From new tool bar select "list box" option Put cursor on area and drag to desired size Right click mouse Select Format Control Within format control select Control tab Input cell references that contain text you want listed
Select View Tool Bars Select Forms toolbar From new tool bar select "list box" option Put cursor on area and drag to desired size Right click mouse Select Format Control Within format control select Control tab Input cell references that contain text you want listed
