excel 2003 visual basic intermediate course - watch window
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

replyReply Thu 6 Dec 2007, 17:05Delegate David said...

David has attended:
Excel Intermediate course

Watch window

How do you create a watch window

For upcoming training course dates see: Pricing & availability

replyReply Thu 13 Dec 2007, 16:45Trainer Stephen said...

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:

Paste functions box quickly

If you want to do a formula using the paste functions box press SHIFT + F3.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard