Moving Data between two userforms

Hello all,

I am new to programming in VBA and using userforms (but learning by doing!). I am trying to do what I have quoted below. In particular,I have the two userforms set up so that I open one and then click a checkbox that opens the second userform. I would like the data I enter into a texbox in the second userform to populate a text box in the first. Could someone help me with some general code to do this?

Originally Posted by dominicb

Good evening scott92

Sounds like you want to dump the contents of textbox1 into a public variable and force textbox 2 to pick them up from there. You might have a problem deciding exactly when textbox2 is to update - ie what event you're going to hang it from.

Are both userforms visible on the screen at the same time? is the updating to take place in real time?

HTH

DominicB

Thanks for any help

Hello Sportsranker,

I don't see why you couldn't use something as simple as:

Please Login or Register  to view this content.

When you type something into TextBox2 on UserForm2 and then exit that textbox, TextBox1 on UserForm1 will update appropriately.

Hope that helps!

maybe...
in module

Please Login or Register  to view this content.

in userfrom one

Please Login or Register  to view this content.

userform two

Please Login or Register  to view this content.

In cases like this I would suggest you consider using one userform, with a multipage contro.

hi sportsranker
dont forget to go back to your first post > Edit > Go Advanced and change the prefix to "Solved"