Checkbox in worksheet

[mikeymay]

I have 15 checkbox's on a worksheet that represent weeks 1 to 15.

Each time one of the checkbox's is click (to either true or false) I want to check if any other checkbox's are selected.

Basically, the checkbox's are there to enable the user to select a range of weeks from 1 to 15. The user can select all weeks or, for example, weeks 7 -12. If a range that isn't all is selected I want to either return an error message saying select a range, or get the code to automatically check all the box's in the range.

 

[RoryA]

Why not use option buttons and add an option for All as well as 1-15.

 

[mikeymay]

How owuld this deal with just a range being selected?

 

[RoryA]

Your question gave me the impression they should only be able to select one option or all - is that not the case?