I have a clock that updates every second :
And I have a sound player
I also have a function that will call this sub when a cell equals to the time
IF(A1 = Clock time), call Sub
inside A1 I have 10:30:00 AM.
My Problem is that it will play this wav file two times. It seems like when it the clock hits 10:30:00 and TRUE, it will play one time, then when it hits 10:30:01 and FALSE, it will play it again
If I manually change the cell to TRUE, it will play it one time. And changing it back to FALSE, wont play it a second time.
Does this have to do with the timing of Excel? Calling it once right at 10:30:00, and then causing a .calculate when it flags to TRUE and calling it again? (Not even sure if this makes sense)
Ive tried rewriting the code from scratch and that I couldn't figure out what the problem was.
Thanks for any help
Bookmarks