98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » General
General
Resolved · Low Priority · Version 2003
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
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
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. |
Excel tip:Display pictures on Chart Data PointReplacing a single chart data point bar with a picture. |