Adding a cell

  • Thread starter Thread starter T.J. Cox
  • Start date Start date
T

T.J. Cox

Is it possible to have a Cell keep track of a total number
when keyed at separate times. Example:
I key the # 24 in a cell then come back to the cell later
and key another 24 hoping that the cell will read 48.
However, I am just writting over the first 24 when I
really want them to add up. I know that a formula cannot
be entered into the cell bacause of the Circular
Reference. What can I do?
 
You could try a couple of event procedures -- one to store in memory what's
in the cell whenever it's selected (SelectionChange), and one to add
whatever's in memory when the value is overwritten (Worksheet_Change,
possibly). David McRitchie has *so* much stuff on events at
http://www.mvps.org/dmcritchie/excel/event.htm

HTH,
Andy
 
Back
Top