Summing values on a Page change event?
I have 24 text boxes on Page0 of a Multipage in a UserForm. I would like to keep a running total of the values in the textboxes or to total them before the user goes to the next Page1 in the Multipage. During the Page_Change event how can I reference all the values on the Page0 in order to summarize the values? I tried summing them as they were entered with this code sTotalChecking = sTotalChecking + ActiveControl.SelectedItem.ActiveControl.Value Me.txtTotalChecking = sTotalChecking However, if a user changes a value from a larger one to a smaller one it doesn't decrement the difference. So if the user types in a 5, sTotalChecking =5 but then if they modify the value to be a 2 sTotalChecking = 7 instead of 3... |
All times are GMT +1. The time now is 09:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com