In the change event for the first two textboxes, put the formula:

tb3 = tb2 - tb1

Mangesh



"stockpick" wrote in message
...
I think this is a simple operation but I can not find the way to do it.
I have a excel user form with 3 text boxes, tb1, tb2 and tb3. I want to
use
tb3 to show the results of the enteries made in tb1 & 2. For example
tb1 = Maximum
tb2 = Minimum
tb3 = Maximum - Minimum
After the entry is made in tb2 then tb3 will automatically show the
calculated result as the user will not be allowed to move onto that
textbox.
At this point the record wil is part of a larger form and not updated to
the
worksheet.

Regards