View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Peter Atherton[_11_] Peter Atherton[_11_] is offline
external usenet poster
 
Posts: 1
Default 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
.

.

.