Disable checkbox when another is selected?

[option]

Hey guys,

I know this sounds simple to do, but here's what I'm trying to tackle:

I have 15 (yes 15!) checkboxes on this spreadsheet. Boxes 1-3 belong to the same "family" and boxes 4-15 belong to a different "family". The user has to make a selection from both "families" in order to continue, and I would like to limit their selection. For example, if Boxes 1 and 7 are checked, disable the rest. I can't seem to wrap my head around this one...any thoughts?

OR! If I could make it so that the user clicks Box 1, then decides Box 2 is a better choice, then Box 2 is checked and Box 1 unchecked.....maybe thats getting too complicated....

 

[smiler44]

when a check box is checked it has a value of true.
could you when each check box gets focus count the number of trues and if 7 and the checkbox that has just got focus does not have a value of true the mouse upevent is ignored and a messgae box displayed informing the user to deslect a checkbox. I think it needs to be the mouse up event as this I think it is the upevent that checks or unchecks a checkbox
if the number of trues = 7 and the checkbox just given focus has a value of true then the mouseup event is allowed as the user is deselecting a checkbox.
however once a check box is checked or unchecked then it must loose focus or the next mouse click event on it may not work.

smiler44

 

[chergh]

Mouse up event???

I would suggest using the checkbox change or click event.

You could then cycle through the collection and make sure the rest are unchecked. Are the checkboxes from the control toolbar or forms toolbar?