Get to know if in Break-Mode and/or on what line?

[onidarbe]

Is there a way to know programmatically that we are in BreakMode and maybe even know on what line?

I found out that using apostrophes one can start OnTime with parameters and not having the error "Can't execute code in break mode".

Application.OnTime now, "'MySub " & now & "'"

This will execute MySub with the time it was started when all running code has finished, not editing a cell or having a MsgBox-popup. But it also executes MySub if the running code has stopped at a break-point. Hard to really debug, because normally the OnTime would wait until all running code has finished.

Knowing the BreakLine would also enable me to have code running in BreakMode and help me writing code with VBProject.VBComponents...

 

[onidarbe]

sorry, the correct syntax =

Application.OnTime now, "'MySub """ & now & """'"

Because it isn't a value, it should be within quotes