G Guest Jun 18, 2006 #1 I am trying to set up Drop Down Menues as part of an Excel Workbook. Can anyone help explain how this is done?
I am trying to set up Drop Down Menues as part of an Excel Workbook. Can anyone help explain how this is done?
V VBA Noob Jun 18, 2006 #2 Hi Madjock, Select the area where you want the drop down. Then click Tools > Data Vaildation. Use the dropdown menu to select Custom. Type in your list using a comma as a seperator e.g Dog,Cat,Mouse If you have a list then the below link should help http://www.contextures.com/xlDataVal01.html VBA Noob
Hi Madjock, Select the area where you want the drop down. Then click Tools > Data Vaildation. Use the dropdown menu to select Custom. Type in your list using a comma as a seperator e.g Dog,Cat,Mouse If you have a list then the below link should help http://www.contextures.com/xlDataVal01.html VBA Noob
B Bob Phillips Jun 18, 2006 #3 See http://www.contextures.com/xlDataVal01.html -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
See http://www.contextures.com/xlDataVal01.html -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
