Userform Checkboxes

G

gti_jobert

Hello all,

This may seem quite trivial but I was wondering if a checkbox on a user
form could check other checkboxes on the same userform. Sounds simple
but I still cant get it to work...using following code:


Code:
--------------------
Private Sub xbAllAreas_Click()
If xbAllAreas.Value = True Then
xbBrivCart.Value = True
xbPace.Value = True
xbThreadRolling.Value = True
xbPodding.Value = True
xbHeading.Value = True
End If
End Sub
 
J

Jim Cone

g,

This works for me on a UserForm...

If CheckBox1.Value = True then
CheckBox2.Value = True
Else
CheckBox2.Value = False
End If

Also...

CheckBox2.Value = CheckBox1.Value

or...

CheckBox2.Value = Not CheckBox1.Value

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



in message
Hello all,
This may seem quite trivial but I was wondering if a checkbox on a user
form could check other checkboxes on the same userform. Sounds simple
but I still cant get it to work...using following code:
Code:
--------------------
Private Sub xbAllAreas_Click()
If xbAllAreas.Value = True Then
xbBrivCart.Value = True
xbPace.Value = True
xbThreadRolling.Value = True
xbPodding.Value = True
xbHeading.Value = True
End If
End Sub
 
Top