Userform: requiring fields and using a check box to set default option boxes

[HeyInKy]

I have a userform that contains 4 combo boxes at the top (labeled cbo(n)) and 2 text boxes (labeled txt1 and txt2). I then have a stand alone check box (chk1) that I want to act as a short cut... more in a minute. After that, I have 12 frames which each contain 2 option buttons, one for Yes (labeled option(n)Y) and one for "No" (these are labeled option(n)N - but are not involved in the data transfer command), 24 buttons total. At the bottom of the form I have another frame which has 9 more check boxes (chk(2-10)). And finally, one last text box used for short memos (txt3).

Below is my code for my "Save & Close" command button to transfer all the data to another worksheet (ws3, "data").

Now I need to write the code for my 'business rules.' This post will just be Part 1 of 2 or 3 rules.

The rules are:
1) all of the first 4 combo boxes and the first 2 text boxes are required, or I'd like a message pop up to say all the fields must be completed.
2) all of the 12 frames with the options boxes are also required (either Yes or No) - EXCEPT
3) if the first check box (chk1) is true, then all options should default to "Yes" and cannot be changed to "No" unless the check box is unchecked.

In this last rule, the first check box acts as a shortcut, that if the user wants to answer everything yes, they won't have to go through and click each one (when the form initializes, the option buttons get set to false, neither yes or no checked by default).

Here's my code, thus far... (haven't made an attempt to try the rules above, sorry... well actually, I have, but it failed miserably

Please Login or Register  to view this content.

[HeyInKy]

With no responses yet, I thought I'd try again and attach my workbook. Thanks!

-HeyInKy