Can a checkbox uncheck another one?

[EtienneD]

I have multiple checkboxes acting as options for the user, and some of those options can't be chosen together. So is it possible to use vba so that when CHECKBOX1 is checked than CHECKBOX2 would be unchecked?

 

[Micron]

Better to use option buttons. By design, choosing one deselects any previously chosen one (if there was one). The direct answer to your question is yes, code can do that, but you can avoid it altogether. Do you have to use checkboxes? Or is this just about box1 vs box2 and you want to have the ability to keep 3,4,5 etc. still checked?

And if 2 is unchecked when 1 is checked, is 1 unchecked when 2 is checked?

 

[HongRu]

Set the two checkboxes in the same GroupName.

Try to press Alt L D M in sequence to enable the Design Mode.
Then double-click the Button and you should find the GroupName above.

 

[Micron]

Set the two checkboxes in the same GroupName.

You posted about option buttons, not checkboxes?

 

[HongRu]

You posted about option buttons, not checkboxes?

You are right.
Sorry.
I made a mistake.

 

[HongRu]

try this
The code should be put in the sheet with the CheckBoxes, not in Module.

Private Sub CheckBox1_Click()
    If CheckBox1 = True Then
        CheckBox2 = False
        CheckBox2.Enabled = False
    End If
    If CheckBox1 = False Then
        CheckBox2.Enabled = True
    End If
End Sub

 

[Micron]

No apologies necessary. If anyone is good at making that sort of mistake, it's me!