'you can do this
Private Sub CommandButton1_Click() 'get from sheet
TextBox1.Text = ActiveSheet.Cells(2, 1)
TextBox2.Text = ActiveSheet.Cells(2, 2)
End Sub
Private Sub CommandButton2_Click() 'put into sheet
ActiveSheet.Cells(2, 1) = TextBox1.Text
ActiveSheet.Cells(2, 2) = TextBox2.Text
End Sub
'and/or perhaps this
Private Sub UserForm_Initialize() 'get from sheet
TextBox1.Text = ActiveSheet.Cells(2, 1)
TextBox2.Text = ActiveSheet.Cells(2, 2)
End Sub