[RESOLVED] Condition to check if a specific cell value exceeds some value

[cavemanpz]

In brief:

I monitor a specific cell value for changes (Worksheet_Change event).

If the cell value will exceed 10 000, I'd like to be informed about it (Msgbox "Your value has just exceeded 10 000").

That's not all:

I'd like to be informed about each time the cell value will exceed another 10 000 (a multiple of 10 000). For example (MsgBox "Your value has just exceeded another 10 000")


For example:

The value is:
9 000 - nothing happens
10 001 = 9 000 + 1 001 - Msgbox "Your value has just exceeded 10 000"
11 000 = 10 001 + 999 - nothing happens
15 000 = 11 000 + 4 000 - nothing happens
20 100 = 15 000 + 5 100 - Msgbox "Your value has just exceeded another 10 000"
20 500 = 20 100 + 400 - nothing happens

etc.