ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do I add Drop down menues in Excel? (https://www.excelbanter.com/excel-worksheet-functions/94610-how-do-i-add-drop-down-menues-excel.html)

Madjock

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?

VBA Noob

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


Bob Phillips

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