Hi,

looks to me like you want to use an Option Buttion (previously called Radio
buttons - if , like me you're the age that you can remember what real
push-buttons looked like on a car-radio).

Add the Option Buttons from the toolbox, and make sure that 'GroupName'
property is set correctly identifying the various groups of buttons you want.

regards,

PauwlL

"instructorjml" wrote:

I have a workbook that has multiple sheets and is using checkboxes that are
checked for a list of questions that have YES, NO, and N/A as possible
responses. (These responses are also tallied on a separate summary sheet.)
Since only one response can be correct, it is possible to make sure that only
one answer can be given for each question? Is there anything that can be done
with an IF statement to make this work?