software

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
------------------------------------------------------------------------
gti_jobert's Profile: www.excelforum.com/member.php...oamp;userid=30634
View this thread: www.excelforum.com/showthread...hreadid=505677g,

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
www.realezsites.com/bus/primitivesoftware
quot;gti_jobertquot; 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