Sending Values To Different Forms

[Figzus]

I know this is probably the easiest question there is but how do you send the value of a textbox in one form to another text box in another form. Thanks for helping.

 

[Enkay62]

Hi.
I suppose you're using excel and so you can load only one form at once.
So you have to use a global variable.
A global variable must be written in a macro module (not in a Userform module) so as to be visible from any routine.

In a module:
(In general area at the top of the module)
declare the variable


Public myvar


In an event (change, afterupdate....) of 1st form textbox
write the code to copy the value


myvar = Me.Textbox1.value


After, in 2d form t.box, in load event or whereever you
prefere, write the code to pass the value to 2d tbox


Me.TextBox1.value = myvar


Hope this helps
Bye
Nick

 

[SkipVought]

or...

Userform2.Textbox1.text = Userform1.Textbox1.text

Skip,
[sub]
[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart! [/sub]