Tracking changes made in cells

[Haas]

Hi All!

I'm working on a spreadsheet model which requires people to input
certain parameters into designated cells in order to price our
product. Once a change has been made in a cell, a Recalc button on the
spreadsheet is pressed and a macro gets activated. However, people
make changes and don't often press the button to re-run the
calculations macro, resulting in the display of obsolete data.

Here's what I'd like to do: I'd like to have a cell near the results
page which would track any or all changes made in input cells. For
example, if I changed 3 parameters in 3 different cells, I'd like this
"tracking" cell to have the number 3 in it - denoting the amount of
cells changed. If this number is greater than 0, I'll have an
"if-then-else" cell adjacent to this tracking cell informing the user
that they must recalc by pressing the Recalc button. How can I go
about achieving this?

Thanks in advance for your help...

Haas

 

[mudraker]

Why not use Worksheet Change function to trigger your macro instead o
the button

This could also be used to trak what cells have been change