A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How to put a module in debug



 
 
Thread Tools Display Modes
  #1  
Old January 20th, 2005, 09:37 PM
Abbey Normal
external usenet poster
 
Posts: n/a
Default 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  
Old January 20th, 2005, 10:46 PM
John Vinson
external usenet poster
 
Posts: n/a
Default

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  
Old January 20th, 2005, 11:11 PM
Abbey Normal
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 09:45 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.