Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Curious interaction W/Win Exp. | Excel Discussion (Misc queries) | |||
Macro interaction | Excel Discussion (Misc queries) | |||
ASP Excel interaction | Excel Discussion (Misc queries) | |||
how set up regression for interaction? | Excel Discussion (Misc queries) | |||
... interaction with Word ... | Excel Discussion (Misc queries) |