| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CheckBox . . .
I am new at Excel. I have on a worksheet 5 check boxes (A3 to A8)
I have them linked to B3 to A8. When a checkbox is activated in A3 then B3 shows "TRUE". I am trying to make sure that only one of the 5 checkboxes can be activated at any one time. Any ideas? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
CheckBox . . .
Be conventional, use OptionButtons !
Regards, Peter T "SJohn" wrote in message ... I am new at Excel. I have on a worksheet 5 check boxes (A3 to A8) I have them linked to B3 to A8. When a checkbox is activated in A3 then B3 shows "TRUE". I am trying to make sure that only one of the 5 checkboxes can be activated at any one time. Any ideas? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
CheckBox . . .
hi
if you want only one check box set to true then set the others to false at the same time. i.e. Private Sub CheckBox1_Click() If CheckBox1 = True Then CheckBox2 = False CheckBox3 = False CheckBox4 = False CheckBox4 = False End If End Sub each check box would need code similar to above but as each check box is checked(set to true) the others are set to false(unchecked) so the second check box code would look something like this.... Private Sub CheckBox2_Click() If CheckBox2 = True Then CheckBox1 = False CheckBox3 = False CheckBox4 = False CheckBox4 = False End If End Sub and so on for each check box. Regards FSt1 "SJohn" wrote: I am new at Excel. I have on a worksheet 5 check boxes (A3 to A8) I have them linked to B3 to A8. When a checkbox is activated in A3 then B3 shows "TRUE". I am trying to make sure that only one of the 5 checkboxes can be activated at any one time. Any ideas? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
CheckBox . . .
Do I have to define the variables? eg. CheckBox1, 2, etc. etc.
"FSt1" wrote: hi if you want only one check box set to true then set the others to false at the same time. i.e. Private Sub CheckBox1_Click() If CheckBox1 = True Then CheckBox2 = False CheckBox3 = False CheckBox4 = False CheckBox4 = False End If End Sub each check box would need code similar to above but as each check box is checked(set to true) the others are set to false(unchecked) so the second check box code would look something like this.... Private Sub CheckBox2_Click() If CheckBox2 = True Then CheckBox1 = False CheckBox3 = False CheckBox4 = False CheckBox4 = False End If End Sub and so on for each check box. Regards FSt1 "SJohn" wrote: I am new at Excel. I have on a worksheet 5 check boxes (A3 to A8) I have them linked to B3 to A8. When a checkbox is activated in A3 then B3 shows "TRUE". I am trying to make sure that only one of the 5 checkboxes can be activated at any one time. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to have Checkbox A uncheck with checked Checkbox B | Excel Discussion (Misc queries) | |||
| link a checkbox in a sheet to a checkbox on a userform? | Excel Programming | |||
| How do I link one checkbox to update another checkbox? | Excel Programming | |||
| checkbox on form reset from checkbox on sheet | Excel Programming | |||
| Checkbox | Excel Discussion (Misc queries) | |||
Linear Mode
