Checkbox Macro

[Jonboy_100]

Help!

Not familiar with Macros or VBA at all but I hope this is quite a simple request.

I have 5 checkboxes:-

CheckBox28
CheckBox32
CheckBox33
CheckBox34
CheckBox35

Basically I want CheckBox28.Value = true when Checkboxes32-35 are true.

Similarly when CheckBox28.Value = false I want Checkboxes32-35 to = false too.

on the flip side I also want Checkboxes 32-35 true when Checkbox28 is true and vice versa.

This is what I got for the first bit: -

Please Login or Register  to view this content.

This works fine...but how do I enable the it to work with doing it the other way?

Any help?

Thanks,

Jonboy.

[mudraker]

Jonboy_100

Welcome to excelforum

Please read forum rules & wrap your VBA code

A thread with the rules is available at the top of each forum or see links below

If you do not understand the VBA code wrap instructions have a look at my last reply in this thread
http://www.excelforum.com/showthread.php?t=583950

[Jonboy_100]

so I did this which works but can I clean up the code to have a subroutine which the clicks call rather than writing them out all the time?

Please Login or Register  to view this content.