Pop-up Alert Help

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.

How does B2 become 0 and how is the 50 get added to A2. Is this through
formulas, a user typing in the values...

Regards
Rowan

Thomas wrote:
> 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.

This worksheet is linked via DDE to a real time stock program. The data is
updated by that program, not by any calculation or manual input on this
worksheet.


"Rowan" wrote:

> How does B2 become 0 and how is the 50 get added to A2. Is this through
> formulas, a user typing in the values...
>
> Regards
> Rowan
>