Trigger a macro using Countdown timer

[rinconpaul]

I'm struggling with vba, and need some help. I want to trigger a macro when the countdown timer reaches a specified time. This is the script I have:

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("$V$4").Value = TimeValue("12:00:00") Then
Call Copy_Race
End If
End Sub

It works in a standalone spreadsheet but not in BetAngel. Is it because the cell V4 is dynamic and continually changing? Any suggestions appreciated.

[floydiano7]

Hmmm...
You can not use Worksheet_Change(ByVal Target As Range)because the values are not inserted manually. You must use Worksheet_Calculate()

[markjacks]

That's right. I think this is possible but it will take you time to figure it out but in the end, Worksheet_Calculate() will work.