Transfer Text from one userform to another userform

I don't have any example of code at all so we'll call the first form "userform1" and the textbox "UserID" with command button "LogIn" and the second form "userform2' and the textbox "UserID" along with misc others. The UserID would need to go from the first to the second userform. This will later be put into an excel sheet but I have that part done.

Any help is greatly appreciated.

Thanks in advance,

-Orestees

Try this method, and let me know if it works.

Inser a Standard Module, and enter the following code:

Please Login or Register  to view this content.

Then in the userform1 code, somewhere appropriate enter

Please Login or Register  to view this content.

Then, in the Userform2 Initialize code, enter the following:

Please Login or Register  to view this content.

Does this work/are you able to follow?

Thanks a ton!! I was able to get it to work perfectly! The issue now is that I'm trying to get the UserID to connect with an intermediate userform and then finally with Userform2 for final output to a sheet. LogIn (Userform1) --> Selection -->Userform2 --> Excel Sheet.
Still messing with it but in the meantime, any clues?

Finally figured it out. Used the below code in the two userforms that were passing the data into the final spreadsheet. WHEW!!! Thanks for the huge jump start BigBas!!

Please Login or Register  to view this content.