Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » General
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
General
Resolved · Low Priority · Version 2003
Reply Mon 20 Jul 2009, 13:43Delegate Vishal said...
Vishal has attended:
Access Introduction course
Access Intermediate course
Excel VBA Intro Intermediate course
Excel VBA Advanced course
Access Advanced course
General
Please explain use of the locals and immediate windows in the VB editor, and provide examples of when you should use them
For upcoming training course dates see: Pricing & availability
RE: General
Hi Vishal
Thank you for your question
The Immediate Window is a window in the VBE where you can enter commands and view the contents of variables while you code is in Break mode. The Debug.Print statement can be used anywhere in your code to display messages or variable values in the Immediate Window. It can therefore be used to keep track of the values of variables and is useful for tracking down bugs that arise from logic errors.
The Locals Window is also useful for tracking down logical flaws in a procedure. It displays all the variables in a procedure and their values. Thus it easy to see exactly what the changing value of each variable is as you step through the code.
Regards
Stephen
|