Q2 -1 triggering some problems, one event jump over ..

[jossari]

Hi,

I am using following code to jump next event:
- if market is closed (CELL F2) or if cell value AS18 = 1 (= "my own calculated cell in certain criterias")

The Cell value AS18 will check some other items from next event and if they are TRUE cell AS18 value will be 1 and then I will want to jump next event.

The problem is now, that this code will jump to next race too fast. I mean althoung next event and its cell value AS18 = 0, this code will jump over this event to the next event. This mean that one event will be missed ..

Is there any possibilities, that program will wait so long that cell value AS18 is certainly updated before program will jump out from if-loop?

BR: AH


If Target.Columns.Count = 16 Then
Application.EnableEvents = False

If Range("A1").Value <> NYKYMARKKINA Then marketMUUTTUNUT = False
If Range("F2").Value = "Closed" Or Range("AS18").Value = 1 Then
If Not marketMUUTTUNUT Then

Range("Q2").Value = -1
marketMUUTTUNUT = True

End If

.....

[alrodopial]

If you change the "Range("Q2").Value = -1
" with the below it will wait for one update

Code: Select all

If Range("Q2").Value = -1 Then
    Range("Q2").ClearContents
Else
    Range("Q2").Value = -1
End If