Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Below is the code I have. i haven't written code in a long time and can't
remember how to write a loop for this - i have about 20 sets of four check boxes and don't want to do this for every one of them - Thanks to any one who can help ------ Private Sub CheckBox1_Click() If CheckBox1 = True Then CheckBox2 = False CheckBox3 = False CheckBox4 = False End If End Sub Private Sub CheckBox2_Click() If CheckBox2 = True Then CheckBox1 = False CheckBox3 = False CheckBox4 = False End If End Sub Private Sub CheckBox3_Click() If CheckBox3 = True Then CheckBox1 = False CheckBox2 = False CheckBox4 = False End If End Sub Private Sub CheckBox4_Click() If CheckBox4 = True Then CheckBox1 = False CheckBox2 = False CheckBox3 = False End If End Sub -- Karissa |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy and move check box (check boxes) with new cell link? | Excel Worksheet Functions | |||
returning back to loop check condition without completing the loop | Excel Programming | |||
Loop through column(s) to check values, perform action based on check | Excel Programming | |||
Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
How do i create a value for check boxes or option boxes | Excel Discussion (Misc queries) |