Text box caption=Cell Value (without command click)

[Bafa]

Private Sub CommandButton4_Click()
Label1.Caption = Worksheets("Data").Range("j20").Value
End Sub

I have this and it works, but what I am really going for is I enter
value in a text box of UserForm1 and it does a calculation and enter
the result in cell J20. When I click the command button labeled "next
it closes that user form and loads UserForm2. What I would like o
UserForm2 is to have a Label filled with the value of J20. The code
have now requires me to click a command button to have the text bo
filled with the value. I want the value filled in the text box upo
loading of the UserForm.

How can I do this. Thanks

 

[Dave Peterson]

If you used:

Private Sub Userform_Initialize()

would that help?

 

[Bafa]

Perfect! You see I am so new to this I didn't know I had UserForm stuf
I could set too. I've just been doing stuff with the Label, Textbox
and Command buttons. Thanks