Keep a running total while using a clearable form
 

I have a form that I am able to clear with a macro reset button. How can I
keep a record of the values within the form and add them to the previous
values that were in that same form before I press the reset button? I want
to keep a running total log is what I guess I'm trying to say.

Keep a running total while using a clearable form
 

Hi

Have a look he
http://www.mcgimpsey.com/excel/accumulator.html

It is well worth reading the intro, as it mentions the lack of traceability
should you enter an incorrect number.

Hope this helps.
Andy.

"1vagrowr" wrote in message
...
I have a form that I am able to clear with a macro reset button. How can I
keep a record of the values within the form and add them to the previous
values that were in that same form before I press the reset button? I
want
to keep a running total log is what I guess I'm trying to say.

Keep a running total while using a clearable form
 

Thanks, I'll check it out. Apologies to all for redundant multiple posts of
mine recently. Posts aren't appearing in the groups I'm putting them in and
I'm thinking they didn't go through.

"Andy" wrote:

Hi

Have a look he
http://www.mcgimpsey.com/excel/accumulator.html

It is well worth reading the intro, as it mentions the lack of traceability
should you enter an incorrect number.

Hope this helps.
Andy.

"1vagrowr" wrote in message
...
I have a form that I am able to clear with a macro reset button. How can I
keep a record of the values within the form and add them to the previous
values that were in that same form before I press the reset button? I
want
to keep a running total log is what I guess I'm trying to say.

Keep a running total while using a clearable form
 

Andy,

That worked great but errors/changes are bound to occur on my end so I can't
use it with any real reliability. Is there no way to have the accumulator
wait until the form is submitted in some way and then do the calculation
instead of immediately calculating upon entry of data?

"Andy" wrote:

Hi

Have a look he
http://www.mcgimpsey.com/excel/accumulator.html

It is well worth reading the intro, as it mentions the lack of traceability
should you enter an incorrect number.

Hope this helps.
Andy.

"1vagrowr" wrote in message
...
I have a form that I am able to clear with a macro reset button. How can I
keep a record of the values within the form and add them to the previous
values that were in that same form before I press the reset button? I
want
to keep a running total log is what I guess I'm trying to say.