LAY input by Macro

[Shaun]

Hi,
i am using this macro

Code: Select all

Sub lay()
Sheets("Control").Range("AN13:AO13").Value = "LAY"
Application.Wait Now + TimeSerial(0, 0, 3)
Sheets("Control").Range("AN13:AO13").Value = ""
End Sub


to pupulate 2 cells i then have 2 BA sheets linked to these cells to place the bets, yet when i run macro it populates the BA sheet with LAY but nothing happens, if i do it manualy it works.

Do i need to activate these cells for it to work?

[GaryRussell]

BA cannot interact with Excel when code is running. Your code is inserting LAY, waiting for 3 seconds then clearing the cells. BA will never see LAY in the trigger cells as it will only get the opportunity to read the trigger cells at the end of your sub when the cells are blank.

[milfor]

The easiest solution is deleting the third and fourth line of your macro.
Deleting the LAY afterwards is not necessary. The bet won't be triggered
more than once because the LAY is not active as soon as the Bet ref column
is filled.