Userform Checkboxes

[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:

Please Login or Register  to view this content.

Any ideas appreciated.....and I dont want to use combo boxes as an alternative unless I really have too! Cheers!

[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



"gti_jobert" wrote 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
--------------------
Any ideas appreciated.....and I dont want to use combo boxes as an
alternative unless I really have too! Cheers!
--
gti_jobert