How to put a module in debug

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Help! I'm new to VB and can't figure out how to put a module into debug mode.
Can anyone point me in the right direction? Thank you
 
Help! I'm new to VB and can't figure out how to put a module into debug mode.
Can anyone point me in the right direction? Thank you
Click to expand...

The simplest way is to set a "breakpoint" - open the module in the VBA
editor and mouseclick in the grey bar on the left of the code editor
window, next to the executable line of code where you want to set the
breakpoint. When you call the code, execution will stop at that point.
You can then use the various options in the Debug menu to singlestep
through the code, "step out" of a subroutine that you know to be
working correctly, "run to cursor" to run through a series of lines,
etc.

John W. Vinson[MVP]
 
Back
Top