Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding Most Recent Values in Col1 -- Summing Matching Values | Excel Discussion (Misc queries) | |||
How do I change a Worksheet_change event to a beforesave event? | Excel Programming | |||
summing up values in a column based on values in 3 other columns | Excel Programming | |||
MsgBox in Enter event causes combobox not to run Change event | Excel Programming | |||
Chart Values that change based on Change event | Excel Programming |