simple math in userform textbox

[inactiveUser214710]

hello everybody!
I have two textboxes to introduce numbers (txt 1;txt 2), and a third textbox where appear automatically the result (for exemple)of the sum of (txt1;text 2). how can i do that?
Thank you

 

[Mindpsyche]

If you have some basic idea of userforms (like me)

Something like this:


Private Sub CommandButton1_Click()
Dim x, y, z As Long
x = Val(Me.TextBox1.Value)
y = Val(Me.TextBox2.Value)
z = x + y
Me.TextBox3.Value = z
End Sub

 

[VoG]

Or simply

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

Note that

Dim x, y, z As Long

declares x and y as Variant and z as Long.

 

[inactiveUser214710]

I appreciate the quick response as well the information that was useful to me, however what I want is,when we enter data in (textbox1 and textbox2), automatically arises its value (the mathematical operation used) into TextBox3, without need to do "enter".
Thanks in advance
Private Sub TextBox3_Enter()
Dim x, y, z As Long
x = Val(Me.TextBox1.Value)
y = Val(Me.TextBox2.Value)
z = x + y
Me.TextBox3.Value = z

z = Val(Me.TextBox1.Value) + Val(Me.TextBox2.Value)

End Sub

 

[VoG]

Try this in the userform's code module

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Me.TextBox3.Value = Val(Me.TextBox1.Value) + Val(Me.TextBox2.Value)
End Sub

Private Sub TextBox2_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Me.TextBox3.Value = Val(Me.TextBox1.Value) + Val(Me.TextBox2.Value)
End Sub

 

[Mindpsyche]

Or simply

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

Note that

Dim x, y, z As Long

declares x and y as Variant and z as Long.

Thanks, I wasn't aware of it

 

[inactiveUser214710]

hi
almost perfect
when I put the value in the box1, the box3 shows the correct value =ok.
when I put another value in the box 2, the box 3 keeps the previous value, so I need to click in box1 for box3 show the sum of the two boxes.
what I need to do for, after put the value in box2, the box3 give the correct value
thank you for your patience

 

[VoG]

Just change the value in textbox1 or textbox2 then click in textbox 3.

 

[inactiveUser214710]

hi
Sorry I do not to understand, but what do you mean by change the value. Is it on texbox propriety or is its value (txtbox1.value), to change for text (textbox1.text)?
if it's text property, which one is it?
Thank you