general

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » General

General

resolvedResolved · 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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Display pictures on Chart Data Point

Replacing a single chart data point bar with a picture.
Step 1: Left click on a bar. Then, wait, and do a second single click on the bar. This will select just one data point.

Step 2: Right click on the bar and select Format Data Point.

Step 3: On the fill effects tab, choose a picture. Browse for a picture for that bar. Indicate if you want it to be stretched or stacked. Repeat for each bar.

View all Excel hints and tips


Server loaded in 0.07 secs.