ActiveX control checkbox to (un-)check all checkboxes

Hello,

I'm using MS Excel 2003 and I have a sheet with altogether 6 ActiveX checkboxes. I want to have a 7th that (un-)checks them all. I can do that for form controls in VBA but not for ActiveX. Here's my code for the form controls:

Please Login or Register  to view this content.

Unfortunately, I have to stick with ActiveX controls because I need them to trigger a worksheet change event.
Thanks.
Stefan

Thanks, Andy. Works great.

Is it actually possible to have the 7th checkbox unchecked as soon as one of the others is unchecked.

Once again, thank you.