MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pull Down Menu


Posted by Eric on October 30, 2001 6:35 PM

The last thing I need to finish my project:

How do I turn a cell into a pulldown menu?

And:

How do I populate the options within that menu?

Thanks.
Eric


Posted by Richard S on October 30, 2001 6:38 PM

Data Validation and refer to a list on your sheet (nt)

Posted by Joe Garza on October 31, 2001 8:02 AM

Create a list anywhere on the spreadsheet.

Then,click on Data on the toolbar above, then validation,on the "settings" tab click "allow", then choose list from the drop down box, then click on the right side of the "source" and highligh your list you created in the first step, then click "OK".