Clear in Selection Tab

[excelhasey]

Can you set a trigger in your selections tab to say place a back or Lay bet then when the bet has been matched place the opposite bet ?? - Do you use a Clear trigger ?? - I have tried it and it Clears but leaves the text "Clear" in the trigger cell and then doesn't place the second bet - Any help ??

[Captain Sensible]

If you're just placing an opposing lay/back once the bet is matched is there any reason why you're not using the tick offsets? You have plenty of options with the offsets from delays to greening etc.

The triggers won't be cleared by BA itself as it could start causing all sorts of problems where people may end up in loops firing off bets, much better to be safe than sorry and have any bets coded to fire. Plus the majority of triggers are usually entered as formulas so that itself would cause problems if BA cleared them.

If you're using VBA just use the fact there's no bet ref and CLEAR in the trigger column to remove it and replace with whatever you're doing, with formulas again you just have to be a bit creative but the fact CLEAR is in the CELL and no bet ref should be a starting point to move on to the next action