hi all,

I'm having some problems in implementing the following. I hava a spreadsheet
that gets live data and I need to compare that with some other cells of mine
based on which I've developed a function that alerts me by showing a msgbox.
Thus suppose the liva data falls below a certain manually entered value, i
get a pop up.

the problem i am facing is that if my live data remains below the manual
value, i keep getting pop ups which I dont want. I need the alert just once
when it falls below that value. I tried using another column as a flag but
when i try to modify a new cell, it doesnt seem to work properly and my
function outputs aren't what they should be. I'm not too sure even if the
logic i'm using is correct. i'm relatively new to vba and excel so if anyone
could help, it would be great. Thanks!!

Abhay