Use MyBets To Log If A Bet Is In Play or Not In Play

[hales548]

Hi All

Is there anyway to use MyBets to log if a bet has been placed 'In Play' or 'Not In Play'?

I have rudimentary knowledge of VBA and everything I've tried so far seems to have failed due to the fact that the sheet is being updated constantly by BA.

The closest code I have to accomplish this is:

Private Sub Worksheet_Change(ByVal Target As Range)

If Range("A2") <> 0 And Worksheets("Sheet1").Range("E2").Value = "Not In Play" Then
Range("G2").Value = "Not In Play"
Else
Range("G2").Clear
End If

End Sub

Sorry to be such a noob!

Ant.

[doncht]

Hi. I found no option to do this as of this point. Is there a work around so far to achieve this?