Possible? Create a popup (flag) when a cell changes value?

  • Basically, I want to creat some notification to the user when a specific set of cells change. I was thinking that I possibly need to name the cells, then create some sort of event when thier values change, and pop up a notification box to the user stating they need to run a specific macro.

    Any ideas would be appreciated.

    I was wondering how hard it would be to chnge the color of the cell when the value changes as well.

    Thankd again all.

  • Changing the color of the cell is easy. Use FORMAT > CONDITIONAL FORMATTING > CELL VALUE IS > Choose cutoff value and set formatting your want when the condition is TRUE. Up to three conditions can be set. The first to fire winds, so place them in acsending order of priority.

    A change detection macro might work for you, but if the cells change value as a result of formula calculuations or automated writes from a database, then the event macro may not trigger. If the user makes the changes, then they should work fine.

  • Hmm, I tried the conditional formatting, but I am not sure it does what I want. The Number will change constantly, so I just want to flag the cell each time it changes. I am not understanding how to setup a conditional format to do just that, with equal to, less than, etc, because I need a reference cell, and I just want the same cell to be flagged when it changes.....I do not understand, but appreciate the help.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!