View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 923
Default Linking checkboxes between userforms

Yes you can, but the two user forms must be loaded in memory. You can load
a userform and then hide it, or load with the hide method and it will be
loaded (if not already) and hidden.

The following code is behind userform1, which when it initialises, loads and
hides userform2. Changes to the checkbox1 on userform1 are 'copied' to
userform2 -checkbox1

Private Sub UserForm_Initialize()
UserForm2.Hide
End Sub

Private Sub CheckBox1_Click()
UserForm2.CheckBox1.Value = CheckBox1.Value
End Sub



--
Cheers
Nigel



wrote in message
oups.com...
Is there a way to link checkboxes 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?