Running Total

[Sherry Hays]

In my mind this sounds simple...

User Input = #
User Input + previous input = running total
Remaining allowed = Allowed - running total

I want to design a form that allows a user to input a number. I wan
that number to add itself to a running total and reset the input box t
0. I want the running total to subtract from the allowed number an
give the result. On the screen I will have 2 of these input boxe
(Exercise points & Food points). Part of the problem is I a
displaying this in Pocket Excel and it will not allow circula
references.

Any suggestions

 

[Nick Hodge]

Sherry

I think this will need a re-think...pocket XL has range names, but no VBA to
work them in this way, no circular reference iteration and I can think of no
way, in this program to do what you need

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)