multiplication
Something like
Dim Tot as Double
Tot = Val(Textbox1.Text) * Val(Textbox2.Text)
Textbox3.Text = Format$(Tot, "# ##0.00")
HTH. Best wishes Harald
"gem" skrev i melding
...
i have a userform for a carpet company which has a combo box with a list
of
available carpets. once the user selects from the list the price of that
certain carpet per sqaure metre is shown in a text box below (each carpet
has
a different price per square metre) that all works fine!!!
BUT.... the user has to type in the number of sqaure metres they need
(which
is fine as they type it manually), but i then need a formula to multiply
these together to get a total cost (baring in mind the prices of the
carpets
are all different and the number of sqaure metres they type in will be
different each time!!!)
e.g. i need the number of sqaure metres multiplied by the price per sqaure
metre!!!
hope i have explained myself properly!
thanks
|