Active X Checkboxes

[TimlmiT]

Gurus,

I have a number of checkboxes in my spread sheet. However I would like 4 of them to act like the options button, whereas if checkbox 1 is checked (true), then checkboxes 2,3 and 4 become unchecked (false). The same holds true if checkbox 2 is checked, then the other 3 are unchecked, and so on.

Since I cannot "record" a macro for this, and I have not been able to find anything on this subject on this site, I have no clue on how to accomplish this.

To keep the spreadsheet looking consistent, I would rather not use the active x options button since I have already built this spread sheet.

Hopefully someone can help.

Thanks in advance,
Tim

[millz]

Assuming your check boxes are named CheckBox1, CheckBox2, etc. Put this in the worksheet's code

Please Login or Register  to view this content.

[TimlmiT]

Works Great!

Thank You!!!