How do I make all other check boxes uncheck when I check a check box?

[MarkSmith64]

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

[#2]

@MarkSmith64 

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.

[#3]

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?

[#4]

@MarkSmith64 

As you have found, all option buttons in a group have the same linked cell.

The value of the linked cell is the index number of the selected option button: 1 if the first option button is selected, 2 if the second option button is selected etc.

Different groups can (and should) have different linked cells.

[#5]

---

@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.

[#6]

@djclements 

Thanks very much I got it to work!