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

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

hi william
thanks but it didnt work!
the price per square metre is in textbox 14
the number of sqaure metres is in textbox 9
and the total cost should show in text box 15
perhaps you could try help me with code using them text boxes so its easy to
understand!
thanks

"William" wrote:

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

Private Sub TextBox14_Change()
TextBox15 = Val(TextBox14) * Val(TextBox9)
End Sub

Private Sub TextBox9_Change()
TextBox15 = Val(TextBox14) * Val(TextBox9)
End Sub


--

Regards

William

XL2003




"gem" wrote in message
...
hi william
thanks but it didnt work!
the price per square metre is in textbox 14
the number of sqaure metres is in textbox 9
and the total cost should show in text box 15
perhaps you could try help me with code using them text boxes so its easy
to
understand!
thanks

"William" wrote:

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