Excel Q2 question

[cooldad]

Using Excel, I like to go through all the markets from a quick pick list. To load the quick pick list, I put value -3 in cell Q2, then I want to loop over all events by putting value -1 in cell Q2.

In BA, I have enabled triggered betting.

I am using VBA to set the value in Q2. When I use the debugger, it works fine, however when I run the macro it doesn´t work. It looks like the value in Q2 disappears too quickly to be picked up by BA.

I tried to add Application.Wait but that doesn´t help either, as VBA is single-threaded.

I got it sort of working using VBA trigger (Application.OnTime (Now + TimeValue("00:00:01")), "UserDefinedFunction"), but this leads to infinite recursion as the user defined function call itself repeatedly.

Does anyone know a better way to implement this?

Thanks!

[cooldad]

I already found what I was doing wrong. It´s not BA that doesn´t pick up the value in Q2, it was the way I implemented my VBA macro that was causing the problem. I was running a separate macro in a continuous loop (taking up 100% CPU time), but now I am using the Worksheet_Change event on the BetAssist worksheet. Now everything works fine.

Sorry for being such a noob!!!