Archive of Mr Excel Message Board
Back to Data in Excel archive index
Back to archive home
drop down listsPosted by Jim Brown on July 31, 2001 7:16 AM
I have set up a program to do home inspections. Each blank cell has several options for completion and I would like to be able to pick from a drop down list or list box so that I can point and click a choice. I am not very familiar with Excel, other than simple operations. Can you help me set up these boxes.
Re: drop down listsPosted by Alix on July 31, 2001 7:29 AM
Your best bet is probably data validation
To use this technique, set up a list of values with your options in somewhere on the spreadsheet (say in cells G1:G10)
Select the cell or cells in which you require the drop-down with this list.
Select the menu item Data, select Validation
In the dialogue box go to the Allow option and choose List
In the Source box enter G1:G10
(or whatever your range of values is)
Ensure the In-Cell Dropdown box is checked
This will allow the user to use a dropdown to select only the values you specified in your list.
If you have more than one list of options, repeat the technique for each cell where required
Hope this helps
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.