Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tracking changes made in cells
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tracking changes made in cells
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 -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to have auto calc cells be blank unless entry made | Excel Worksheet Functions | |||
HOW I PRINT MY PAGE,MADE IN EXCEL,WITH CELLS & COLUMS | New Users to Excel | |||
Need help Coding my cells correctly-3 comparisons to be made | Excel Discussion (Misc queries) | |||
Can an array be made of discontinuous cells of the same row? | Excel Discussion (Misc queries) | |||
Can formulas in cells be made to remain if the data is deleted? | New Users to Excel |