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?
You posted about option buttons, not checkboxes?Set the two checkboxes in the same GroupName.
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