What i would like to add to this spreadsheet is when the first market is selected the second market is then selected 10 seconds later, the 3rd market is then selected 10 seconds later and so on... until the last race has been selected using the -1 trigger in cell Q2. This can be achieved by using cell D1 which has the start time of the next race. When cell D1 has no time in it(not populated) the -1 trigger stops.
The existing code:
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Columns.Count = 16 Then Application.EnableEvents = False If triggerQuickPickListReload Then triggerQuickPickListReload = False Range("Q2").Value = -3 triggerFirstMarketSelect = True Else If triggerFirstMarketSelect Then triggerFirstMarketSelect = False Range("Q2").Value = -5 End If End If Application.EnableEvents = True End If End Sub
I've tried the Gruss forum and i find the forum like a morgue. Very hard to get anyone to help.
Any Betfairians out there who can sort this please?
Not sure if it was you who was asking a couple of weeks ago.
My advice is to e-mail Gary & Mark, who are very switched on, and will always help (Gary wrote an entire programme for me).
Cannot ask for more....great people and for only £6.00 a month!
Not sure if it was you who was asking a couple of weeks ago.My advice is to e-mail Gary & Mark, who are very switched on, and will always help (Gary wrote an entire programme for me).Cannot ask for more....great people and for only £6.00 a month!
I find from their forum they do not want to help individuals. Rather just post a link to a similar thread and hope you work it out so not to get swamped with requests.
Yes it was me the other week. Automated betting takes up all my fecking time!!
I find from their forum they do not want to help individuals. Rather just post a link to a similar thread and hope you work it out so not to get swamped with requests.Yes it was me the other week. Automated betting takes up all my fecking time!!
http://stackoverflow.com/questions/2319683/vba-macro-on-timer-style-to-run-code-every-set-number-of-seconds-i-e-120-seconI'd try the delay the line after you get a value
I'm not so familiar with excel, but with vba code in a module in an access database, you can step through the code with F8 and use the watch window to see variable values. You can also use stop points, so code runs to a point then stops. So you can test sections of code. You can do things by trial and error in real time and see what happens.
I'm not so familiar with excel, but with vba code in a module in an access database, you can step through the code with F8 and use the watch window to see variable values. You can also use stop points, so code runs to a point then stops. So you can t