UserForm if checkbox is checked then check the others and viceversa

Hello everyone!

I'm new to Excel Userforms and VBA, and I need a little help.
I have a Userform with 4 Checkboxes, named from Checkbox 1 thru Ckeckbox 4, and I want to do the following:

-If Checkbox 1 is true, then all the other checkboxes are true
-If Checkbox 1 is false, then all the other checkboxes are false (these were the easier )
-If one or two of the Checkboxes 2,3,4 is selected, then I want that Checkbox 1 became "Null"
-If all the three Checkboxes (2,3,4) are checked, then I want Checkbox 1 to be automatically became true. Is this posible?

My code looks like this:

Please Login or Register  to view this content.

Use OptionButton instead.

I'm not familiar with option buttons, I can put more than one option?

@sintek: The first part of the code I made with If statements because I have separate name for each checkbox. The case where Checkbox1 will be selected if the other three are selected I want to resolve without the need to press a buton, automaitcally, just like in the first case

Yes, but with this method CheckBox1 will be selected even if only one of the Checkboxes is selected, but I want to be selected only when all the three of them are selected. Anyway, thanks for help

I would like to use this code, but I don't know why isn't working:

Please Login or Register  to view this content.

What can I change in this code to make working?

1) Add a Class module and name it as EventControl and paste following code.

Please Login or Register  to view this content.

2) UserForm code (name user form as UserForm1)

Please Login or Register  to view this content.

3) To a standard module (add one if you haven't got any)
to a general declaration area

Please Login or Register  to view this content.

Hi Winom,

No, I don't want this, anyway, thanks for the idea

@ jindon

I made all the steps you mentioned, but nothing happens when I select Checkboxes 2,3 and 4

..................................

Thank you very much. You helped me a lot

That's working great. Thanks mikerickson