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.

Hi

Have a look here:
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" <[email protected]> wrote in message
news:[email protected]...
>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.

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 here:
> 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" <[email protected]> wrote in message
> news:[email protected]...
> >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.
>
>
>

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 here:
> 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" <[email protected]> wrote in message
> news:[email protected]...
> >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.
>
>
>