pull down box

S

sowetoddid

How can I create a pull down menu to choose the contents of a cell?
want to restrict the users input to 5 different values
 
H

He4Giv

Go to Data>Validation and select LIST under the "Allow" window and in the source box type your 5 items you want people to select from each separated by a coma
Make sure your in the cell where you want the validation to show up

----- Bob Phillips wrote: ----

Take a look at Data Validation in Help

Debra Dalgleish has a good web page on i
http://www.contextures.com/xlDataVal01.htm

-

HT

Bob Phillip
... looking out across Poole Harbour to the Purbeck
(remove nothere from the email address if mailing direct
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Search using a combo box and then creating a report. 4
Dynamic Naming of Form Button 3
create pull down menu 1
Drop down list control value in vba 2
Font drop-down menu very slow 0
Link a text box based on drop down box with four options MS Word 365 0
How do we put typical mathematical and equations symbols into Word Office Maths Editor? 0
Set as Default Template not working 0

Top