UserForm Interaction
Ryan,
You can, but as a Userform is a special instance of a class module, precede
it with the class (or form) name. For instance, this
TextBox1.Text = UserForm1.TextBox1.Text
puts the value of textbox1 on Userform1 intgo Textbox1 of the current shown
form. If the forms are modal they must both still be loaded
Show is the form equivalent of activate. Load brings it to memory, Show
presents it.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Ryan Ericson" wrote in message
...
Is it possible for one UserForm to access data from
another UserForm? OR can you activate UserForm as you
would books or spreadsheets?
|