getting a VBA macro to run continuously

[zingomax]

Hi

New to VBA and battling
with it
I have this working as a simple way to update market

Sub start()

If Range("F26").Value = 0 Then
Range("Q2").Value = -1
Else: Range("Q2").Value = ""

End If

End Sub


But it only works if I run it manually. How can I get it to run every few seconds to pick up when F26 goes from a number to zero?

[zingomax]

Perhaps a better option would be

Sub start()

If Range("F2").Value = "Closed" Then
Range("Q2").Value = -1
Else: Range("Q2").Value = ""

End If

End Sub

But again not sure how to make it run continuously

[MarkRussell]

Hi,

Have a look at this thread:-
http://www.gruss-software.co.uk/forum/viewtopic.php?t=5132

Regards,
Mark

[zingomax]

This is prbably too simple as approach as I could end up switching markets in the niddle of the next race.
I'll pose a different help question in a new topic

[zingomax]

Thanks gary - that helped me understand what all the <>16 was all about.

Is there some good code to switch to the new market about 10 second before the scheduled off and stay in it in play until 10 second before the next one?

So you get the first part of the race and don't switch in the middle ever?
I came across your code to switch just before the off but this loses the inplay period

[MarkRussell]

Hi,

If you get the latest Beta version then cell D1 will display the official start time of the next race in your Quick Pick List.
If you are on the last race then the cell will be blank.
You can compare the current time with D1 to decide when to switch markets.
You should be able to adapt the example code that you already have to do this.
NB: However, if a race starts late or the race times are too close together then the switch to the new market can still happen when you don't want it to.

Regards,
Mark