passing userform values

[rickblunt]

Hello, I have two userforms and I have a commandbutton on useform1 that calls for userform2. On userform1 I have a text value in textbox1 that I want to pass on to textbox1 on userform2 when it launches. I thought the code below should be all I need, but when I launch userform 2 the textbox remains blank. Did a couple of quick searches through the forum and this does seem to be the correct code. But I cant figure out what I am missing. Userform1 stays open while I have userform2 open, so it should still see the value in the textbox.... Should I not use the initialize event? I appreciate any input - Rick

Private Sub UserForm_Initialize()


Userform2.textbox1.Text = Userform1.TextBox1.Text




End Sub

 

[Peter h]

Hello, I have two userforms and I have a commandbutton on useform1 that calls for userform2. On userform1 I have a text value in textbox1 that I want to pass on to textbox1 on userform2 when it launches. I thought the code below should be all I need, but when I launch userform 2 the textbox remains blank. Did a couple of quick searches through the forum and this does seem to be the correct code. But I cant figure out what I am missing. Userform1 stays open while I have userform2 open, so it should still see the value in the textbox.... Should I not use the initialize event? I appreciate any input - Rick

Private Sub UserForm_Initialize()


Userform2.textbox1.Text = Userform1.TextBox1.Text






End Sub

That code works just fine for me.

Edit: Maybe post your whole code, and we can help you spot something that might be causing it.

 

[rickblunt]

Thanks for replying Peter H, and thank you for confirming this for me. I was pulling one of those "all nighters" and when I thought I was done with the project my boss, threw in one of those, "before you leave could you add in this?" kinds of things. When I got back in this morning I realized that buried in the code the button that I was using to call that second userform was emptying out the contents of the textbox as it passed it onto the second textbox.
I appreciate your input on this - thanks again.

 

[Peter h]

Thanks for replying Peter H, and thank you for confirming this for me. I was pulling one of those "all nighters" and when I thought I was done with the project my boss, threw in one of those, "before you leave could you add in this?" kinds of things. When I got back in this morning I realized that buried in the code the button that I was using to call that second userform was emptying out the contents of the textbox as it passed it onto the second textbox.
I appreciate your input on this - thanks again.

I know how that goes. Lol. Glad to hear you got it all worked out.