I would assume something like
and so forth..
Private Sub txtTotal_Change() 'update textbox as values are entered i if InvestAsset1 <> 0 then txtTotal = txtTotal + InvestAsset1 if InvestAsset2 <> 0 then txtTotal = txtTotal + InvestAsset2
However, it would be a lot easier if you could post the workbook as an example, so we see what code goes where and what the controls are called
Last edited by wamp; 05-12-2010 at 03:33 PM.
_______________________________________________
Remember:
Read the rules!
Use code tags! Place [CODE] before the first line of code and [/CODE] after the last line of code.
Mark your post [SOLVED] if it has been answered satisfactorily.
To do this, click EDIT in your original post, click GO ADVANCED and set the PREFIX. It helps everybody!
If you are approve (or disapprove) of any members response to your problem, please click theicon underneath their post and comment. It matters.
Here is the Excel Spreadsheet with the code. Thank you for the help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks