HELP WITH USERFORMS NEEDED!!!

[Guest]

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

 

[William]

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

(e-mail address removed)

 

[Guest]

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]

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

(e-mail address removed)