How can I put in a control box in Excel for Yes/No responses?

M

Mary A Walthall

I want to set up cells in Excel to receive Yes/No choices. I can do this so
easily in Access 2003, but have not done it in Excel 2003. Is it possible?
Thanks.
 
B

BobT

How about a drop down list in each cell with "Yes" and "No" as the choices?
If so, here's how:

1. On another sheet (you could hide the sheet after if you want) put Yes
and No in two cells (e.g. A1 and A2).

2. Back on your input sheet, highlight the range you want to have the drop
down lists.

3. From the DATA menu, choose VALIDATION.

4. Choose LIST.

5. In SOURCE you can click on the button to the right and go highlight you
choices (the Yes and No on the other sheet).

6. You can then get fancy and add an input and error message.

Once you click OK your cells will have a drop down button on the right and
your user's won't be able to choose anything other than the list you selected.

Hope this helps.

Bob Tulk
MOUS
 
Q

Qull666

Hello BobT, I have tried this many times but my validation for list doesn't
work by referring 2 worksheets. It has to be done in 1 worksheet.

I am on a Exel 9 - 2000

How do I get it to work on 2 worksheets.

Thanks.
 
B

bda75

Instead of referring to a range, you can enter a comma delimited list
of values. In the Source box, enter: Yes,No
 
B

BobT

Name the list of options (the Yes/No range) and use the name of the range as
your validation list.
 
Top