excel 2003 visual basic intermediate course - 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