how do I add Drop down menues in Excel?
I am trying to set up Drop Down Menues as part of an Excel Workbook. Can
anyone help explain how this is done? |
how do I add Drop down menues in Excel?
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 -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=553007 |
how do I add Drop down menues in Excel?
See http://www.contextures.com/xlDataVal01.html
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Madjock" wrote in message ... I am trying to set up Drop Down Menues as part of an Excel Workbook. Can anyone help explain how this is done? |
All times are GMT +1. The time now is 05:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com