Adding numerical values in text-boxes on a user-form is not straightforward. Watch the video first and then study the VBA code:

Private Sub CommandButton1_Click()
TextBox3.Value = Val(TextBox1) + Val(TextBox2.Value)
End Sub