Select one checkbox to Deselect another
using control toolbox checkboxes, i put them within _click events
(when they get checked):
Option Explicit
Private Sub CheckBox1_Click()
CheckBox2.Value = False
CheckBox3.Value = False
End Sub
==========================
Private Sub CheckBox2_Click()
CheckBox1.Value = False
CheckBox3.Value = False
End Sub
=========================
Private Sub CheckBox3_Click()
CheckBox1.Value = False
CheckBox2.Value = False
End Sub
=========================
did one for each checkbox, as mentioned previously.
hope it helps.
susan
On May 19, 1:06*pm, Susan wrote:
if checkbox1.value = true then
* *checkbox2.value = false
* *checkbox3.value = false
end if
if checkbox2.value = true then
* *checkbox1.value = false
* *checkbox3.value = false
end if
if checkbox3.value = true then
* *checkbox1.value = false
* *checkbox2.value = false
end if
like that
hth
susan
On May 19, 9:35*am, Keith74 wrote:
Yes, it's completely possible. You just have to add code to pick up
when the value of a checkbox changes and reset the other checkboxes.
Theres loads of code samples on the web.- Hide quoted text -
- Show quoted text -
|