Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check Box influencing other Check Boxes
Add this code to the userform module:
Private Sub CheckBox6_Click() Dim i As Integer If CheckBox6.Value = True Then For i = 1 To 5 Me.Controls("CheckBox" & i).Value = True Next i End If End Sub Cheers, Dave. -----Original Message----- Using Excel 97... I have 6 checkboxes on a UserForm. 5 of them can be individually checked but by checking CheckBox6 I would like the other 5 checkboxes to be automatically "checked" as well. Does anyone know how to do this? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and move check box (check boxes) with new cell link? | Excel Worksheet Functions | |||
How do I increase the size of check in check boxes | Excel Discussion (Misc queries) | |||
Check All Check Boxes | Excel Discussion (Misc queries) | |||
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) |