Clever Geek Handbook

VBA - Set a property in a subroutine to automatically go into debugging

This question is specifically about the get / let property of the code in a class module, but I think the solution would apply to any subroutine.

There should be a property that tells vba to transition the function in break mode automatically (even when you press a step in the / F 8 key). Obviously such a thing exists for inline subtitles, VB classes and functions, since the debugger doesn't step into them, but I can't seem to find a way to apply it to my code. What is it?!

It will make my life easier when debugging.

+3


source to share


2 answers


Along with the Shift+, F8there is a button on the Debug toolbar.

enter image description here

Bonus round:



If you forgot to press Shiftand be inside the class anyway, you can exit by pressing Ctrl+ Shift+F8

And go back by right clicking on the line you want to go back to and select Set Next Expression.

One final note, the reason the debugger is not included in the "built-in" classes is because this code is not written in VBA. It is hidden behind a COM Interop wall and is written in a completely different language.

+2


source


If I understand correctly what you are asking, you need to step over, not step.



Try Shift+ F8instead F8.

+2


source






More articles:


All Articles