Observing macros calculating

[Doug Starkey]

Used to be that in Excel4 Macros, if you were stepping through a macro,
you could watch the macro calculate an expression. eg.

"=FORMULA("=4*r38c2*453.59237/128/(1+r39c2)"

could be watched as Excel replaced "r38c2" with the value of that cell,
and "r39c2" with the value stored in that cell.

In Excel 5, with the introduction of Visual Basic commands, you could
use something called "Instant Watch" in the Visual Basic debugger to
watch the same sort of activity in a VB module.

Now I'm using Excel 2001. But I can't find anything like the "Instant
Watch" function when "stepping" through a Visual Basic module. Is this
functionality gone altogether? Or is it simply missing from the Mac
version?

--
Doug Starkey
Network Administrator
Pecan Deluxe Candy Company
(e-mail address removed)
(remove "NOSPAMPLEASE" to reply)

 

[Jim Gordon]

Hi

All of the available tools are on the "Debug" toolbar. Instant-watch is not
among them. You can use the immediate window to determine current values,
use "debug print" or use msg boxes within your code. The stack button
provides additional insight as to what is happening as you step through
code.

-Jim Gordon
Mac MVP

All responses should be made to this newsgroup within the same thread.
Thanks.

About Microsoft MVPs:
http://www.mvps.org/

Search for help with the free Google search Excel add-in:
<http://www.rondebruin.nl/Google.htm>