Check box logic question

[Ailsa02]

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

 

[Gary Brown]

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

 

[Ailsa02]

Gary,

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

Ailsa

 

[T. Valko]

Use option buttons. This is their normal behavior.

 

[ggraves1968]

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?