I am a NOOBIE in Excel VBA programming. I try to be clear with my question as
I am 12 time zones away.

Column A is 'Total' and column B 'Supply'. Whenever the quantity in 'Supply'
is reduced, 'Total' is increased by the corresponding amount. When this
happens twice during the last 10 mins. I would like to have a pop-up to
alert me to this event. After I clicked on 'OK' on the pop-up, the function
is deactivated only for that particular cell for just that particular day.
This function is needed for the entire Total range B2:B450.

Example:
A2 starts with 200 and B2 initially 50. If B2 becomes zero and A2 adds on
the 50 to become 250, a pop-up appears.