HELP WITH USERFORMS NEEDED!!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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)
 
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
 
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)
 
Back
Top