Taming the VBA_debugger
Hi,
I often use the "debugger" in the VBE to debug my scripts - that is, I use breakpoints or I step through the script line by line by pressing F8 repeatedly.
What happens quite often is that either
- after a while, the system just decides that going line by line is too slow and
just executes the remainder of the script at normal speed
OR
- the moment I execute a line of code opening a workbook that contains
macros itself, the VBE_code_window shows that macro instead of the one
I'm just working on and the execution_line_highlight is gone.
Can anybody confirm to me why this tends to happen and what I can do to avoid it?
Thanks a lot!
Best regards,
Officer_Bierschnitt
P.S.: Can that have something to do with the fact that there is VBA_code in one of the sheets here rather than in a general module?
P.P.S.: Maybe, but that is apparently not all - now I have moved the code to a general module, but the same thing still happens ...
Last edited by Officer_Bierschnitt; 11-18-2015 at 03:42 AM.
Reason: additional info
|