ba.Placebet when in-running time delay

[lanips]

Hi

I have some VBA code that loops through a number of football selections and places bets according to liability controls. The placebet function is the standard one shown below

Backref(i) = ba.placebet(BetID, "B", Odds(i, 1), BackStake)

This works fine pre match but crashes in-play presumably as the function has to wait 3-8 seconds for a bet reference from Betfair and so delays returning a function result.

Is there anyway around this? I'm a novice with VBA and tried

"On Error resume Next"

in the hope to crudely ignore the error but this doesn't work.

Any ideas much appreciated.

Thanks

Max

[GaryRussell]

The statement would just take longer to execute in play as you say, but I don't understand how this can cause your code to crash. What error message does it generate?

[lanips]

Thanks for your response.

Sorry, a bit misleading as no actual error message, just "egg timing" until each bet has gone up on Betfair.

There are 2 issues.

1) I am trying to place two bets, back and lay, in-play on several markets simultaneously. The For loop I currently use means that each market takes 3-8 seconds to go up before the next market is processed. Is there any way to put up multiple bets at the same time to only have to face one Betfair in-running time delay?

My non COM version seems to allow this but I have to wait for all Backs (or Lays) to go up before placing the Lays (or Backs) as you can only put one command in the trigger cell at a time.

2) The in-play time delay causes the code to egg time. I am trying to give control back to Excel with DoEvents so my prices can decay but with no success.

Thanks again for your response.

Cheers

Max