Why not use radio buttons (small circles) as they are designed specifically
to be mutually exclusive (only one can be selected at a time).
--
HTH...

Jim Thomlinson


"BrianG" wrote:

I would am attempting to create two clickboxes where when one is
turned On the other is turned Off automatically. No luck so far. Any
suggestions would be appreciated. Below are two of the codes I have
tried.

Private Sub CheckBox1_Click()
CheckBox1.Value = True
CheckBox2.Value = False
End Sub

Private Sub CheckBox2_Click()
CheckBox2.Value = True
CheckBox1.Value = False
End Sub

AND

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

Private Sub CheckBox2_Click()
If CheckBox1.Value = True Then
CheckBox1.Value = False
End If
End Sub


TIA,

BrianG