LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
stockpick
 
Posts: n/a
Default Use a text box to calculate and show results in a user form

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to calculate and then show up as a percent? Amuse Excel Worksheet Functions 1 July 10th 05 10:19 PM
Calculate APR from ARY Ron737 Excel Worksheet Functions 2 July 1st 05 02:30 PM
How do I calculate amortization to show months? Maria New Users to Excel 1 June 2nd 05 08:41 AM
I need help to get formula to calculate royalties recouped with sa nono404 Excel Worksheet Functions 4 March 10th 05 09:20 PM
How can I show Feet and inches in a Excel cell? Magama13 Excel Discussion (Misc queries) 1 January 28th 05 03:27 PM


All times are GMT +1. The time now is 08:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"