View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Checkboxes, AND, OR statements

No link like a controlsource.

You can link with code in events

Userform1.cbox1.Value = Userform2.cbox3.Value

Userform1.hide

hides the userform but doesn't unload it so you can still access its
controls (read from and write to)

--
Regards,
Tom Ogilvy


wrote in message
ups.com...
Thanks, this looks great. Also, is there a way to link the check boxes
between 2 different user forms (say ckbCoast is in frmLocal and ckbSFR
is in frmInfo)? Perhaps there's Hide Me function that would keep one
user form open, just not shown on the screen giving the next form the
ability to link back to it. Any ideas?