Group Checkboxes to only allow on "checked" box

[Guest]

I am trying to format an excel spreadsheet that contains three checkboxes for
one particular question.

My goal is to link all three checkboxes listed for (yes, no, N/A) response
to only allow on box to be checked for an answer.

Is there a way to format this in excel?

 

[Guest]

Try using Radio Buttons instead... but if you insist on using checkboxes I
can write a code that would only allow one checkbox to be checked.

 

[Guest]

Would the radio buttons offer a sum of the answers provided (i.e. yes, no,
N/A) we are trying to capture on the "true" answer.

how would I assign the format to capture that?

There are several tabs for the workbook already filled out with the
checkboxes, would it be easier to assign the code for that instead of redoing
all the sheets to have radio buttons?

 

[Guest]

Well how to you have it set up for the true/false answers.... cause you can
link the radio buttons, but they give values of 1 and 2

In the cell with the true/false answers you can change it to,
=IF(RadioButton1LinkedCell = 1,"TRUE","FALSE")

So whatever radio button you click the number will go to 1 and the answer
will go to true.

 

[Guest]

I tried out the radio buttons
I have three available for one question in cells M4,N4,O4 all linked to Q4
for an answer.

In the formula how do I reference the linked cell M4, N4, or O4?

Maybe the checkboxes would better since we already have them formatted to
provide a TRUE or FALSE response.

 

[Guest]

Well, if you right click on the Radio Buttons, and link it to cells, you will
get some 1 and 2s as answers. 1 = Checked, 2 = Unchecked.

So set up 3 cells that you link to the 3 radio buttons.

I'm having trouble understanding how you are doing it with the checkboxes.
Wherever your true/false answer was for the check boxes, make that formula
say something like,

If(RadioButton1="1",DoSomething,DoSomethingElse)

 

[Guest]

If you need a formula, let me know what the checkbox names are in the order
that they show up on the sheet.