MrExcel Publishing
Your One Stop for Excel Tips & Solutions

pull down buttons


Posted by steve on July 05, 2001 1:25 PM

I wanted to create a pull-down button to give the options in a cell.
For example, I want the user to only be able to select the value in a cell from 4 possiblities: 33, 66, 133, and 200. How would I do this??
Thanks in advance for your help!


Posted by Ben O. on July 05, 2001 1:49 PM

You'll want to use Data Validation for this. Select the cells you want to apply the validation to, then select Validation from the Data menu.

Under where is says Allow, select List. Under source, you can either select a range of cells that have your values, or just type in 33, 66, 133, 200.

It's that simple.

-Ben