Coding Yes/No option buttons to not allow check boxes or require check boxes

As part of a userform, I have several Yes/No option buttons in 12 frames (in all, 12 yes/no questions totaling 24 buttons), followed by another frame containing 9 check boxes. The check boxes are named chk2 thru chk10, numbered consecutively (In a another section of the form, I have chk1, which is not important for my questions here).

In the last yes/no question, the option buttons are named option12Y and option12N (for yes and no, respectively), and they default is false for both. The end user must select either yes or no to submit the form.

I would like the following rules:

If option12Y is true, none of the check boxes 2-10 can be checked. The following code handles this rather well:

Please Login or Register  to view this content.

Next rule, if option12N is true, then AT LEAST ONE of the check boxes 2 thru 10 MUST be checked true.

Here's my code for that:

Please Login or Register  to view this content.

Problem #1: I get the error message "At least one of the 9 items must be checked..." when option12Y is true, even though the check boxes are grayed out and not enabled via my first code. Obviously, this message should not appear.

Prolem #2: When option12N is true, it will let me save even if no check boxes are checked - I don't care if more than 1 is checked, but I can't get it to follow the rule that at least 1 needs checked and the message in the code above displayed.

Any help on how my code should look to satisfy my 2 rules is greatly appreciated!

-HeyInKy

Problem 1 went away and I no longer get the message for option2Y being true. But it did not solve problem 2, as it is still saving the data in the userform even if check boxes 2 thro 10 are not checked.

Any other thoughts?

Thanks!

-HeyInKy

Changing the ("chk" & x) = True (not False!! Duh!) did the trick. Thanks.