Hi Gem

Try the following (although you'll need some error checking to ensure there
are valid numbers in TaxtBox1 and TextBox2).


Private Sub TextBox1_Change()
TextBox3 = Val(TextBox1) * Val(TextBox2)
End Sub


Private Sub TextBox2_Change()
TextBox3 = Val(TextBox1) * Val(TextBox2)
End Sub


--

Regards

William

XL2003




"gem" wrote in message
...
i have a user form for a carpet company and need to know how to work out
the
total cost. i have a text box with the price per square metre and a text
box
which allows the user to type in the amount of square metres required.
what i
want is once this has been typed in, i want the total cost to be
automatically calculated by multiplying the price per square metre with
the
number of sqaure metres!!! what formula do i use? can anyone help?
thanks