adding 2 numbers - userform

[lezawang]

Hi
I have userform which has 3 text boxes. I want to add 2 numbers and put the result in the 3 box when I click on + command button. Everything is working fine but if I only entered one number in first box and left the other box empty and then press + button, I get error message. How can I improve the code below. Thank you so much.

Private Sub myadd_Click()
result.Value = CInt(first.Value) + CInt(second.Value)
End Sub

 

[Fluff]

Replace the CInt with Val

 

[lezawang]

Thank you. Val working better

 

[Fluff]

You're welcome & thanks for the feedback