How do I create a series of check boxes that when you check the second box,
the first box will automatically uncheck?

Private Sub CheckBox1_Change()
If CheckBox1 = True Then
CheckBox2 = False
End If
End Sub

Private Sub CheckBox2_Change()
If CheckBox2 = True Then
CheckBox1 = False
End If
End Sub

--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown


"Ailsa02" wrote:

How do I create a series of check boxes that when you check the second box,
the first box will automatically uncheck?

Gary,

You are soooo the man! Thank you! That worked perfectly!

Ailsa

"Gary Brown" wrote:

Private Sub CheckBox1_Change()
If CheckBox1 = True Then
CheckBox2 = False
End If
End Sub

Private Sub CheckBox2_Change()
If CheckBox2 = True Then
CheckBox1 = False
End If
End Sub

--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown


"Ailsa02" wrote:

How do I create a series of check boxes that when you check the second box,
the first box will automatically uncheck?

Use option buttons. This is their normal behavior.

--
Biff
Microsoft Excel MVP


"Ailsa02" wrote in message
...
How do I create a series of check boxes that when you check the second
box,
the first box will automatically uncheck?

I have a group of check boxes that if you click on one I want to increase a
series of discounts offered and when you uncheck it reverts back to the
original data. The trick is that I have 10 choices that I want to increase
or decrease based on the accumulation of boxes checked and if none are
checked it goes back to my original data.

Any ideas?
--
Ggraves


"Gary Brown" wrote:

Private Sub CheckBox1_Change()
If CheckBox1 = True Then
CheckBox2 = False
End If
End Sub

Private Sub CheckBox2_Change()
If CheckBox2 = True Then
CheckBox1 = False
End If
End Sub

--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown


"Ailsa02" wrote:

How do I create a series of check boxes that when you check the second box,
the first box will automatically uncheck?