Saving data in form before sending it to email address

Who is NO ONE ?

Some action on the UserForm should Transfer the information to the worksheet.

You have to make it happen though.

Something like...

Private Sub CommandButton1_Click()
    Range("A65536").End(xlUp).Offset(1, 0) = TextBox1
    Range("A65536").End(xlUp).Offset(0, 1) = TextBox2

End Sub