Any example with CreateWaitableTimer SetWaitableTimer

[onidarbe]

I'm trying to construct a OnTime in milliseconds that keeps running after a debug break-mode.

- Application.OnTime gives "Can't execute code in break mode" !
- Using the API SetTimer in "user32" gives a fatal error when it is calling a sub while you are in break-mode!
- SetCoalescableTimer would probably solve it with the uToleranceDelay, but it is only for Windows 8, I got 7 64x

But I've found something here in French! using CreateWaitableTimer SetWaitableTimer. Maybe this is something, but it is written in a class which I would love to see working in a compact module-vba-code.

So if anyone has some example code for a timer that can continue after a break-mode, please let me know...

thanks,
Michel

 

[onidarbe]

I know it's an old question, but the solution is for all still seeking it, to use apostrophes around the procedure and add at least 1 parameter. This way there is no error "Can't execute code in break mode". It will just execute after all running VBA code has ended and not editing a cell and no MsgBox is up.

Application.OnTime now, "[B]'[/B]MySub """ & textPar & """[B]'[/B]"
Sub MySub (optional xPar)
End Sub

 

[pxcpycpzc]

Another 2 years.

well done onidarbe, thats a good find about OnTime.
I have checked it out with 64 bit Excel 2013 vba and it works for me.

For others reading this, I found a good description that explained the argument syntax at
http://markrowlinson.co.uk/articles.php?id=10

Also, this is the only post I have found that says 64bit crashes with SetTimer when in break mode. That is a problem I am presently struggling with.

My question for onidarbe (if its not too late):
You said you wanted to get OnTime working with msec. Did you have any joy? From my reading and checks, I thought it was not possible. I am chasing a 100 msec delay - any suggestions?

thanks