G Guest Feb 14, 2004 #1 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
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
B Bob Phillips Feb 14, 2004 #2 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) Steve said: I have 2 Check biixes that are related within the entry of data, how can Click to expand... I linmk them where they both can't be checked?
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) Steve said: I have 2 Check biixes that are related within the entry of data, how can Click to expand... I linmk them where they both can't be checked?
J John Wilson Feb 14, 2004 #3 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 Steve said: I have 2 Check biixes that are related within the entry of data, how can Click to expand... I linmk them where they both can't be checked?
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 Steve said: I have 2 Check biixes that are related within the entry of data, how can Click to expand... I linmk them where they both can't be checked?
