How to Transfer TextBox Value from 1st Form to 2nd Form at TextBox

Need Help! I have a form in VBA Excel, I need to automatically transfer the value of my scanned qr code to 2nd form (kindly see attached snapshot for clarity). I will need code for this. Thanks, I hope some one will help me in this problem! Thank you in advance.Form_Scan.JPG

You need to setup a variable to store the value between the UserForms.

Assumption: UserForms are called UserForm1 & UserForm2, The input fields are called TextBox1 in both UserForms. Amend code to suit your requirements.


In UserForm1

Private Sub CommandButton1_Click()
    MyVal = TextBox1.Value
    UserForm2.Show
    Unload Me
End Sub

In UserForm2

Private Sub UserForm_Initialize()
    TextBox1.Value = MyVal
End Sub

Declare variable in a standard Module

Public MyVal

You are welcome

...and thanks for the rep!