Checkbox Either/Or

[Steve]

I have 2 Check biixes that are related within the entry of data, how can I linmk them where they both can't be checked
Thanks

 

[Bob Phillips]

Steve,

Use option buttons. By default they do what you want.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

I have 2 Check biixes that are related within the entry of data, how can

I linmk them where they both can't be checked?

 

[John Wilson]

Steve,

You could code them this way to accomplish what you want:

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

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

but..................

Using Option Buttons like Bob suggested would be a better alternative.

John

I have 2 Check biixes that are related within the entry of data, how can

I linmk them where they both can't be checked?