Thanks JLatham. it worked!!!
one more thing though. there is only one digit after the decimal point,how
do i change that in the properties?


"JLatham" wrote:

You could also try these - basically says that after typing something into
one of the text boxes, verify that both text boxes contain numeric
information and if they do, then multiply them and put the result in a label
as its caption.

I chose the Label instead of a text box because it's more difficult for the
user to accidentally alter what's displayed on one of them. But text box
would work just like in Nick Hodge's suggestion.

Here's code:

Private Sub txt_Num1_AfterUpdate()

If IsNumeric(Me!txt_Num1) And IsNumeric(Me!txt_Num2) Then
Me!lbl_Result.Caption = Me!txt_Num1 * Me!txt_Num2
End If

End Sub

Private Sub txt_Num2_AfterUpdate()
If IsNumeric(Me!txt_Num1) And IsNumeric(Me!txt_Num2) Then
Me!lbl_Result.Caption = Me!txt_Num1 * Me!txt_Num2
End If
End Sub



"gem" wrote:

i need to multiply two numbers from two different text boxes then show the
answer in another text box, this is on an excel userform!
Can anyone help?
thanks