VBE break line-number?

**onidarbe** · 05-15-2015, 05:06 PM

Is there a way to get the linenumber where the manual step-by-step running code in debug-mode is? So which line is at that moment marked yellow?

Is there a way to know if the code is in debug-mode? Maybe to know if in the menu the Debug/Step Over Shift+F8 is grayed out or not?

thanks

**Leith Ross** · 05-15-2015, 05:23 PM

Hello onidarbe,

Line numbers can be added when you write your code, but there is no auto-number feature.

If the line is highlighted, why do you need to know the line number?

**onidarbe** · 05-17-2015, 06:16 PM

Any OnTime event is normally being executed after vba ends but also when vba has halted in break-mode. The sequence of called procedures in debug-mode is thereby differently of normal code execution. Hard to debug your code then! ;-)

So I'd like to postpone a OnTime event while in breakmode, calling and restarting itself when we are in breakmode. But for this I first need to find out that we are in breakmode! So I thought maybe the Application.VBE has also a property of where the executing code is.