adding 2 numbers in textbox - vba

[lezawang]

Hi
I created a form which has 3 text boxes and 4 cmd buttons. user will enter number in the first box and another number in the second box and click on +,-,*, / buttons and the result will be in box 3. The -,*, and / work fine but I noticed the + is not.

If user enter 1 in the firstbox and 2 in the secondbox and click on + then the 3rd box will show 12 not 3 ! why is that? and why other operations are ok except +. Thank you very much

Private Sub plus_Click()
   dim x as integer
   x = first.Value + second.Value
   result.Value = x
End Sub

 

[Trebor76]

Hi lezawang,

The code looks correct Maybe you've assigned the code that multiplies to the command button for adding?

Note that an Integer variable can only hold numbers in the range of -32,768 to 32,767 so you will receive an error if the total is outside this range.

HTH

Robert

 

[lezawang]

Thanks for your reply. No that is not the case. Even if that the case then the result would have been 2 not 12
first number 1
second number is 2

the result should be 3 (if add)
or 2 if multiplication

but I am getting 12, that seems excel concatenating 1 and 2 that is why I am getting 12. Thanks

 

[ZVI]

Hi, try using this:
x = CInt(first.Value) + CInt(Second.Value)