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
