Questionnaire sheet: Select "yes" or "no," and only one can be selected

[bpatterson]

Hello,

I have a questionnaire on an Excel spreadsheet with 20 yes/no questions. What is the best way to create a spreadsheet with the option of a "yes" or "no" box that can be checked one or the other exclusively? For example:


Are you God? No

But not:

Are you God? Yes No

It needs to be set up so either "yes" or "no" is possible to mark, not both.

Many thanks for any hints.

[Biff]

Hi!

One way would be to use a data validation drop down list with the selections
of either Yes or No.

Biff

"bpatterson" <[email protected]> wrote
in message news:[email protected]...
>
> Hello,
>
> I have a questionnaire on an Excel spreadsheet with 20 yes/no
> questions. What is the best way to create a spreadsheet with the option
> of a "yes" or "no" box that can be checked one or the other exclusively?
> For example:
>
>
> Are you God? No
>
> But not:
>
> Are you God? Yes No
>
> It needs to be set up so either "yes" or "no" is possible to mark, not
> both.
>
> Many thanks for any hints.
>
>
> --
> bpatterson
> ------------------------------------------------------------------------
> bpatterson's Profile:
> http://www.excelforum.com/member.php...o&userid=33478
> View this thread: http://www.excelforum.com/showthread...hreadid=532795
>

[MyVeryOwnSelf]

> I have a questionnaire on an Excel spreadsheet with 20 yes/no
> questions. What is the best way to create a spreadsheet with the option
> of a "yes" or "no" box that can be checked one or the other exclusively?

One easy way is to use data validation. The user sees a pull-down list for
each question -- not a check box -- so it’s not exactly what you asked for.

Select the cells where answers should go and use:
Data > Validation

In the “Settings” tab, choose
Allow > List
For the “Source” put
Yes,No

If you want to get more elaborate, fill in the “Input Message” and “Error
Alert” tabs too.

Note: using “Error Alert” you can stop the user from typing in an erroneous
value but you can’t stop the user from pasting one in.