Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiplication
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiplication
Using the change event for each text box, add code that multiplies the value
of the two text boxes and populates a lable with the resulting amount. The code will look something like this (you will have to validate that both text boxes contian numbers before running this code)... Label1 = format(value(textbox1.text) * value(textbox2.text), "#,##0.00") -- HTH... Jim Thomlinson "gem" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiplication
Sorry... Where I have Value, use Val (similar to Harald's code...). I would
be more inclined to use a leble than a Text Box (as Harald uses) as text boxes are designed for the user to enter text into where as lables are designed to display text with no ability for the user to change the value... -- HTH... Jim Thomlinson "Jim Thomlinson" wrote: Using the change event for each text box, add code that multiplies the value of the two text boxes and populates a lable with the resulting amount. The code will look something like this (you will have to validate that both text boxes contian numbers before running this code)... Label1 = format(value(textbox1.text) * value(textbox2.text), "#,##0.00") -- HTH... Jim Thomlinson "gem" wrote: 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiplication
"Jim Thomlinson" skrev i melding
... I would be more inclined to use a leble than a Text Box (as Harald uses) as text boxes are designed for the user to enter text into where as lables are designed to display text with no ability for the user to change the value... Hi Jim Sometimes users should be allowed to Ctrl-C the result, which would be a reason to use a textbox. Otherwise labels make more sense, absolutely. Best wishes Harald |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiplication | Excel Worksheet Functions | |||
multiplication | Excel Worksheet Functions | |||
Multiplication problem- Please Help! | Excel Discussion (Misc queries) | |||
Transpose multiplication | Excel Discussion (Misc queries) | |||
Multiplication Table | Setting up and Configuration of Excel |