If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to put a module in debug
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 |
#2
|
|||
|
|||
On Thu, 20 Jan 2005 13:37:19 -0800, Abbey Normal
wrote: 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 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] |
#3
|
|||
|
|||
Thank you, I couldn't find that anywhere in the help text. Appreciate it!
"John Vinson" wrote: On Thu, 20 Jan 2005 13:37:19 -0800, Abbey Normal wrote: 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 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] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Visual C++ Debug Library. Debug Error! Abnormal program termination | John | General Discussion | 1 | September 25th, 2004 09:00 PM |
How to Rename a module using VBA code | allissonlu | General Discussion | 3 | August 17th, 2004 11:03 PM |
outlook opens and flashes closed | General Discussion | 5 | July 24th, 2004 11:00 AM | |
Searching Records Using a (Global?) Module | Lucky Man Cree | New Users | 0 | June 15th, 2004 09:52 PM |
Using a module in a query | Fatz | Running & Setting Up Queries | 4 | June 2nd, 2004 03:17 PM |