Help with some code

[Revol82]

I have some vba code that constantly observes the market, but i want it to stop after the lay bet. how can i do it?
Example: Over 2,5 goals, the bot puts a back bet when it reaches 2.5 let's say a goal is scored and the odd goes to 1.5 then the bot places the lay bet.
After this i want it to stop observing the market for it not to place another back bet in case it reaches again 2.5.

Ty

[Captain Sensible]

Just set a flag in your code after the laybet is placed, for eaxmple set it to 1 and amend the original back bet routine to add another criteria meaning it will only fire when the flag isn't 1

[Revol82]

Ty, true, wanst thinking

If Sheet3.Range("D2").Value = "00:30:00"

How can i put this code to work? it doesnt recognize the value 00:30:00

[Captain Sensible]

Ty, true, wanst thinking

If Sheet3.Range("D2").Value = "00:30:00"

How can i put this code to work? it doesnt recognize the value 00:30:00

Excel treats time as a numerical value rather than text, you can use ,

If Sheet3.Range("D2").Value =TIMEVALUE("00:30:00")

or even the numerical value for 00:30:00

If Sheet3.Range("D2").Value = 0.0208333333

Might also be worth you using greater than , less than 00:30:00 or even a range of times in your coding as it's easy to miss a set time slot, only need a slow refresh for a set time to be missed