excel 2003 visual basic intermediate course - watch window

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel 2003 visual basic intermediate course - Watch window

excel 2003 visual basic intermediate course - Watch window

resolvedResolved · Low Priority · Version Standard

David has attended:
Excel Intermediate course

Watch window

How do you create a watch window

RE: Watch window

Hi David,

Thank you for your question

You use the watch window to view the values of expressions when you application enters break mode.

To add a watch expression you should:-

Select the expression that you wish to evaluate in the code window

Click on the Add watch option on the debug menu. The add watch dialog will open with the expression inserted.

Select the context for the expression by defining the relevant procedure or module

When you run the code the value of the expression will appear in the watch window at each breakpoint

Regards

Stephen


 

Excel tip:

Using basic functions without doing formulas

When you highlight figures Autocalc tells you the total in the bottom right of the screen, but if you right click on the sum it will give you some basic functions. The functions are Min, Max, Average, Sum, Count, and Count Nums.

View all Excel hints and tips


Server loaded in 0.08 secs.