Subscriber only lesson.
Sign up to this course to view this lesson.
Using the Stop keyword
How to use the Stop keyword in a debugging context.
When to use
To create a permanent Breakpoint code that lasts between Excel sessions. (Useful for multi-session debugging, or when you haven't been able to complete all code branches in development.)
- The Stop keyword is essentially a Breakpoint that remains between Excel sessions.
- Implement a Stop by typing Stop on any line
- The code will run to this point and then break (stop) so that you can continue with debugging
Hints & tips
- Don't forget to remove Stop lines before releasing the code (or your users will be launched into the Visual Basic Editor.)
Lesson notes are only available for subscribers.