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?
|