XL97: Watch Window Does Not Use Procedure Call Context (161736)
The information in this article applies to:
- Microsoft Excel 97 for Windows
This article was previously published under Q161736 SYMPTOMS
The Watch Window may not display the value of a watch expression in the
appropriate context of the selected procedure call.
CAUSE
When you run a procedure in the Immediate Window as part of the debugging
process for your macro, it will be added to the list of procedure calls in
the Call Stack dialog box. This functionality helps you trace the operation
of your code. However, if you select a procedure in the Call Stack dialog
box that is listed more than once and click Show, the current value of your
watch expression does not change to the context of the selected procedure.
For example, if your watch expression is a variable, and you run a
procedure in the Immediate Window multiple times, and you change the value
of the variable each time, the Call Stack dialog box cannot be used to
trace the different values of the variable. The value of the variable in
the Watch Window is the value at the last running of the procedure,
regardless of the instance of the procedure call selected in the Call Stack
dialog box.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. REFERENCES
For more information about the Watch window, click the Office Assistant,
type watch, click Search, and then click to view "Watch Window".
For more information about the Immediate window, click the Office
Assistant, type immediate, click Search, and then click to view
"Immediate Window".
For more information about the Call Stack Window, click the Office
Assistant, type calls, click Search, and then click to view "Call Stack
Command (View Menu)".
Modification Type: | Major | Last Reviewed: | 11/7/2000 |
---|
Keywords: | kbprb kbProgramming KB161736 |
---|
|