pull down box

[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

 

[Dan E]

This should explain it:

http://www.contextures.com/xlDataVal01.html

Dan E

 

[Bob Phillips]

Take a look at Data Validation in Help.

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

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Guest]

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