Archive of Mr Excel Message Board


Back to Data in Excel archive index
Back to archive home

How to create a drop down menu

Posted by marilyn on March 13, 2001 4:06 AM
Please help,
How do you create a drop down menu in excel?

Re: How to create a drop down menu

Posted by Dave Hawley on March 13, 2001 4:39 AM


Hi marilyn

Sounds like you are refering to Validation. As you are wanting a drop down list I would recommend highlighting K1:K100 (or any other range) and the naming it "MyRange". Include some extra rows in the range so that your Validation list will expand automatically if you happen to add more entries. You will see what I mean in a minute.


1. Select cell A1. Go to Data>Validation. Select "List" from the "Allow" box.

2. In the "Source" box type: =MyRange. Make sure the "Ignore Blank" and "In cell drop down" are checked.

3. Click the "Input message" tab and type a message if you want one to appear whenever A1 is selected.

4.Click the "Error alert" tab and type a message if you want one to appear IF a entry that is not part of the list is typed in the cell.

5. Set the error alert level from the "Style" box. Now click OK and we're done!


Select cell A1 and you can now pick from your list.
Type another entry in the named range and it too will become part of your list. This is why I suggested including some blank cells.

Hope this helps.

Dave


OzGrid Business Applications


Re: How to create a drop down menu

Posted by Marilyn on March 14, 2001 3:29 AM


Thanks a lot for the help Dave, I'll try it today
Marilyn


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.