View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Debra Dalgleish[_2_] Debra Dalgleish[_2_] is offline
external usenet poster
 
Posts: 52
Default pulldown boxes

You can use Data Validation:

1. Select the cell(s) in which you want the list
2. Choose DataValidation.
3. From the Allow drop-down list, choose List
4. In the Source box, type: Yes, No
5. Click OK.

Note: Users will be required to match the case in the list, (e.g. "no"
will be an invalid entry because of the lower case letters)

You can also refer to a list on worksheet, which is not case sensitive.
There are some instructions he

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

david wrote:
I was wondering if it was possible to make a pulldown in a
cell. So, that I could make them select from the pulldown
menu choices. For example in a certain cell, I just want
them to select yes or no.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html