Delay trigger InPlay

[Optimus_Primed]

Hi all,

I do most of my trading in play and i was wondering is there a way for your trigger to 'wait' for a certain amount of seconds before firing?

For example i want to back a horse 20 seconds after going in play, then if not matched in say 5 seconds - cancel bet.

Now i know how to trigger the last two things (BACK-F5-IP), but i don't want to fire in straight away.

Cheers for any help.

[lindemann]

Optimus,

I'm not a VBA expert but I can copy and paste with the best of them. This piece of code (written by Gary I think) puts time in play into Cell T1 so you can trigger your bets using =IF(T1>20,.......etc



Dim timeInPlay As Date
Dim turnedInPlay As Boolean

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Columns.Count = 16 Then
If Range("E2").Value = "In Play" Then
If Not turnedInPlay Then
turnedInPlay = True
timeInPlay = Now
End If
Else
turnedInPlay = False
End If
If turnedInPlay Then Range("T1").Value = DateDiff("s", timeInPlay, Now) Else Range("T1").Value = 0
End If
End Sub

[Optimus_Primed]

Optimus,

I'm not a VBA expert but I can copy and paste with the best of them. This piece of code (written by Gary I think) puts time in play into Cell T1 so you can trigger your bets using =IF(T1>20,.......etc

Looks like exactly what i was after - will test it out tomorrow - thanks heaps lindermann

[Optimus_Primed]

Tested and worked perfectly - thanks again