Linking Checkboxes

[Smurfit-Stone]

Hello Board,
Is there a way to get checkboxes to act like radio buttons? I need checkboxes to respond like radio buttons where if one is checked the other is not etc. I think a IF statement might do it, but I'm not sure how to write it...something like =if(z2=true,z12=false) and if(z12=true,z2=false). I have a sheet with a lot of checkboxes already on it, so I'd like to just add a formula to get them to act like radio buttons, (I don't like radio buttons and dealing with those frames or whatever their called) I have lots of checkboxes. Thanks in advance.

 

[kpark91]

Usually the option button is the best way to go cuz it's much less of a hassle.
However, if you insist.

You could loop through an array of strings (names of the checkboxes) and then use Control(string) in order to manipulate the 'selected' object.

or you could loop through the whole checkboxes (google loop through checkboxes) and then find the code and manipulate it as needed.

The only problem of these two will be that you will need to add the code to every single change event of the checkboxes.