check box - allow only one check mark per category
 

I have created several check boxes (through design mode) on my worksheet. My
questions require one of three answers (Yes, No or N/A). How do I set it up
such that only one can be checked for each question? Example, if "Yes" is
already checked and I decide to check "No" instead, it removes the check mark
from "Yes" once I click on "No".

check box - allow only one check mark per category
 

Try using option buttons instead. Only one option button can be selected at
a time. You may have to group the buttons to keep one row of them isolated
from another row of them.

Biff

"Jessik" wrote in message
...
I have created several check boxes (through design mode) on my worksheet.
My
questions require one of three answers (Yes, No or N/A). How do I set it
up
such that only one can be checked for each question? Example, if "Yes" is
already checked and I decide to check "No" instead, it removes the check
mark
from "Yes" once I click on "No".