Change Option Buttons Based on Checkboxes in Userform

[SoothSailor]

Hey all,
So here's what I already have coded successfully:

In Frame 1 I have option buttons for:

• All Days
• Weekdays
• Other

and in Frame 2 I have Checkboxes for

• Monday
• Tuesday
• Wednesday
• Thursday
• Friday
• Saturday
• Sunday

So far, I've made it so that when you click the "All Days" option, checks in the Monday - Sunday boxes automatically appear
when you click the "Weekdays" option, checks in the Monday - Friday boxes automatically appear
when you click the "Other" option, all checkboxes are set to false so the user can select individual days.

What I need, is for the option buttons to change with the checkboxes. So if the user clicks "Other" but checks the Monday - Friday boxes, then the "Weekdays" option would switch to "true". If all of the days are checked, the "All days" option button would be set to "True". If any combination of days other than Mon-Fri and Mon-Sun are checked, then the "Other" option would be set to "True".

Essentially, the Option buttons change the check boxes only. I need the Option buttons to change the check boxes and the check boxes to change the Option buttons.

Here's the code so far:
(option buttons are OptAllDays, OptWeekdays, and OptOther)

Thank you!

Please Login or Register  to view this content.

[LJMetzger]

Hi SoothSailor,

There are two issues we have to solve:
a. Getting the logic correct.
b. Preventing the CheckBoxes/OptionButtons from cross-pollinating each other. The cross-pollination problem is the reason for the Global boolean variable.

By definition, CheckBoxes are independent and don't need to be in a Frame. The OptionButtons can be in a Frame or they can be in the same Group. The Group Property can be assigned in the 'Properties' Window by assigning all the OptionButtons in the group to the same Group Name.

Lewis

Try replacing your UserForm code that you posted with the following (tested and working):

Please Login or Register  to view this content.