Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Garry
The code for a form goes in a special Form Module. You probabley have a Command button on the form to process it. Double click this button to open the Form Module. and enter your code there. It will be attached to Private Sub Button_Click. If you are adding the data to a list in a sheet you can do the code in the module and enter the values into a new line. If you want a demo form write direct. regards Peter -----Original Message----- Peter, I get an error message when I try to insert the code. I am inserting it into the Control Spurce box. Is this right? Gary -----Original Message----- Garry Code it as something like; Textbox3=textbox2-textbox1 and Textbox4=textbox4/textbox3 Reagrds Peter -----Original Message----- I am creating a ueserform that shows asks the user to enter a cost price and a selling price for an item. Is ther a way of having another box (textbox?)which will show the result of a calculation based upon the two figures entered e.g Profit made in absolute and percentage terms. Thanks for your help . . . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Calculation Result Display Failure | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
textbox result to label | Excel Programming | |||
Creating Userforms and textbox numbers | Excel Programming |