Hi all. Can anyone please assist me with a code on how to uncheck 2 checkboxes if 1 checkbox in same row is ticked.
I have 3 checkboxes in every row. Currently, I have a code but it's not stable to do the job. I originally have checkbox from form control but code doesn't work, so I changed it to activeX control yet more than 2 boxes are found to have tick mark.

I use checkbox to state the status of an equipment either Available & in good condition, Not available, and Faulty. With these status, it cannot happen that 2 boxes are checked at the same time.

Please help! It will really be appreciated. Thanks in advance!-hydz1213

Option Explicit

Private Sub CheckBox1_Click()
CheckBox2 = Not (CheckBox1)
CheckBox3 = Not (CheckBox1)
End Sub

Private Sub CheckBox2_Click()
CheckBox1 = Not (CheckBox2)
CheckBox3.Visible = True
End Sub

Private Sub CheckBox3_Click()
CheckBox1 = Not (CheckBox3)
CheckBox2 = Not (CheckBox3)
End Sub