excel file fires a bet twice

[kevinstaight]

Sorry, thought that if you have 10 markets start at the same time you need 2 secs each so vb repeat script at least 10 secs to be safe 15 secs.

sub updatemyclock()
Application.OnTime Now + TimeValue("00:00:20"), "my_Procedure"
end sub

sub anything()
Sheets("Control").Range("C8").Value = Format(Now), "hh:mm:ss")
UpdateMyClock
end sub

then use if statement to check cell and run script only when that cell / clock changes.

[nigelk]

Don't know if this'll help, but I see people are still using Range("O6:O##") to clear the status cells.

Since the sheets were updated a while ago, range O6 is now the global status cell. Don’t think that should be cleared if you only want 1 bet?

[maik79]

thanks a lot. i am not really into vba and really have to try hard to understand you. i dont even know how i got the makro

but thanks for the suggestions. The approach to let the makro check the last clock actualisation and thus determine when it is safe to delete PLACED seems to me the most plausible one. i will come back to this.