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" <(E-Mail Removed)> wrote in message
news:AF3C0970-DFE4-4DCD-BCFF-(E-Mail Removed)...
> 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?