I am not sure I understand.
what is TextBox1. I use Excel 2000 and I checked in Excel 2003, I do not see
any textbox  in the forms toolbar. So I guess you are using textboxes in the
userform.
if you want to copy from the worksheet to the textbox in your user form  you
may use something like:
Me.TextBox1.Text = Worksheets(1).Cells(1, 1)
You can use this only after you load  the userform
if you want then to transfer data  from a textbox in the userform to the
worksheet you may use something like
Private Sub CommandButton1_Click()
Worksheets(1).Cells(3, 3) = Me.TextBox1.Text
Unload Me 'close the userform and return to the workbook.
End Sub