View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
raw[_9_] raw[_9_] is offline
external usenet poster
 
Posts: 1
Default Check box in user form


Hi

I have a user form with 2 check box, but i need help with some code
I want a error message to appear if box boxes are ticked or both are
not

Also how do unload check boxes and option buttons so after closing the
next person using the form has no choice but to select one (this is in
case someone select a option but the next person forgets to and leaves
the option before which is the wrong one for them!!!!) Hope that makes
sense

here is some of my code already

If Not (OptionButton6 Or OptionButton7) Then
MsgBox "No option for job type track only or compelet, please
select."
OptionButton6.SetFocus
Exit Sub

Thanks


--
raw
------------------------------------------------------------------------
raw's Profile: http://www.excelforum.com/member.php...o&userid=28312
View this thread: http://www.excelforum.com/showthread...hreadid=480443