View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_5_] Bob Phillips[_5_] is offline
external usenet poster
 
Posts: 620
Default 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?