Userforms - Display result of a calculation in a textbox
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
.
.
.
|