Take a look at Debra Dalgleish's Contextures website:

http://www.contextures.com/xlform01.html

That link showcases Dave Peterson's code that builds the form automatically
for you.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"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?