Copying Data between userforms

**paxile2k** · 12-27-2010, 01:58 PM

I have userform1 and userform2, userform1 has a button to open userform2, userform2 has 3 textboxes, textbox1, textbox2, textbox3, textbox3 = textbox1 * textbox2, which value to textbox3 is linked to a command button, the command button does the calculations to assign the value of textbox3, there is a ok button which will close the userform2 and return to userform1, userform1 has a textbox3, i am trying to have the value of userform2.textbox3 copy to userform1.textbox3

code is on userform2

Please Login or Register  to view this content.

I have also trying delclaring a public variable for textbox1 * textbox2 as textcalc, but the value is still copying over to the userform1 textbox3. any help would be appreciated. Thanks in advance

I have attached a basic version that i am trying to work with

**jaslake** · 12-27-2010, 07:01 PM

Hi paxile2k

You're code unloads the form before the line can be executed

Please Login or Register  to view this content.

John

**paxile2k** · 12-27-2010, 07:20 PM

Originally Posted by jaslake

Hi paxile2k

You're code unloads the form before the line can be executed

Please Login or Register  to view this content.

John

Wow, Thankyou, I completely did not take into consideration on the placement of the unload me event. Thankyou for your assistance. somehow i knew it would be easy.