Hello All,

I have a VBA/Excel issue that I can't seem to figure out. I have a spreadsheet that reacts to live data feeds, and occasionally certain live feeds come in incorrectly. As of right now, i have conditional statements to alert me if something is triggered. The twist is that it is really only substantial if the alert/condition exists for more then ~5minutes. So, here's the issue -- How do I create a conditional stopwatch/timer that will begin a countdown once the initial conditional statement is true and restart if the initial conditional statement switches to false.

To simplify, If A1 is true => start a stop watch. If A1 stops being true => Stop the stop watch and reset it back to zero. And of course a secondary alert conditional statement if Stopwatch>5minutes (but that won't need to be macro code).

Thank you!!