Forum Discussion
How do I make all other check boxes uncheck when I check a check box?
Hi,
I have multiple (groups of 3) check boxes.
I want only 1 check box (in the group) to be checked at a time so when you check another box, the others uncheck.
Google doesn't seem to be much help!
Thanks in advance for any help
Mark
Assuming that you use Form Controls on a worksheet:
- Use option buttons (aka radio buttons) instead of check boxes.
- Draw a group box (also from Form Controls) around each group of option buttons.
- Hi, thanks for your response.
All buttons are linked to the same cell even if they are grouped, you can't link a group to a certain cell. I'd already tried this and was all working ok until I needed the second group to be independent from the first. Is there a way of linking different buttons to different cells?
MarkSmith64 wrote:
All buttons are linked to the same cell even if they are grouped, you can't link a group to a certain cell. I'd already tried this and was all working ok until I needed the second group to be independent from the first. Is there a way of linking different buttons to different cells?The key to having multiple group boxes linked to different cells is to insert each group box FIRST, then insert option buttons within each group box. If you insert the option buttons first, they will all be part of the "worksheet" group and will all be linked to the same cell... drawing a group box around the option buttons after the fact has no effect on the cell link.
