UserForm1.TextBox2.Value = UserForm2.TextBox1.Text -----not working after first time

[Miler13]

Hello, I looked through a bunch of places and couldn't come up with an answer to help me. The problem I am having is that a macro I have is based on having the previous textbox having an input that was pulled from the previous input box. Example. First userform box pops up, and you input a persons name. Second userform that pops up should have the first textbox with the persons name, and another textbox to input a number.

On the first go around, everything works great, but on the second time it does not work.

my code

Private Sub UserForm_Initialize()
UserForm1.TextBox2.Value = UserForm2.TextBox1.Value
End Sub

 

[steve the fish]

What does it do? It will work as many times as you want if the Userform is still open with the Textbox still containing the required text. Id imagine you have closed the userform so making it unavailable.