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

--
Baf
-----------------------------------------------------------------------
Bafa's Profile: http://www.excelforum.com/member.php...fo&userid=3774
View this thread: http://www.excelforum.com/showthread.php?threadid=57360