A strange behavior of a Boolean variable

[mencoxx]

Ciao,

I run a device monitoring program and noticed that at the turn of midnight, the program would stop, debugging I noticed that the variable 'flag' would change state on its own.

I solved it, I know I had to use the API Sleep function, but still it's really weird.

I attach a test example.

Thanks a lot.
Domenico

 

[Gasman]

Would it be anything to do with this?

Timer function (Visual Basic for Applications)

VBA language reference

learn.microsoft.com

Plus you have
If Flag = False
Else
Flag = False
End if

 

[mencoxx]

Thank you for your interest.
If the Timer function after midnight resets, then the delay is zero but I don't think it affects the variable 'flag'.

Ciao