How can one follow follow the step-by-step execution of a
macro.

Thanks

use STEP into/out (F8) in debug menu in VBE
or first set some breakpoints with F9, then fire up your procedures and
they will stop on the breakpoints.


If the LOCALS window is visible, you can see all your variables,
or add some watches on variables you'd like to monitor.



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Louis" wrote:

How can one follow follow the step-by-step execution of a
macro.

Thanks

It worked! thanks

I didn't really understand how I could watch the state of
my variables as the macro excecutes itself.

I'm running Excel97

Thanks for your help so far.




-----Original Message-----


use STEP into/out (F8) in debug menu in VBE
or first set some breakpoints with F9, then fire up your
procedures and
they will stop on the breakpoints.


If the LOCALS window is visible, you can see all your
variables,
or add some watches on variables you'd like to monitor.



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Louis" wrote:

How can one follow follow the step-by-step execution of
a
macro.

Thanks



.

Ignore this message if you understand it now. (I wasn't sure if you didn't
before or don't currently.)

When you're stepping through your code, you can let the cursor linger over a
variable and you'll see a tooltip pop up with its current value.

You can also rightclick on a variable and select "Add Watch"
Then you can see the watch window by:
View|Watch window
(if you closed it)


Louis wrote:

It worked! thanks

I didn't really understand how I could watch the state of
my variables as the macro excecutes itself.

I'm running Excel97

Thanks for your help so far.

-----Original Message-----


use STEP into/out (F8) in debug menu in VBE
or first set some breakpoints with F9, then fire up your
procedures and
they will stop on the breakpoints.


If the LOCALS window is visible, you can see all your
variables,
or add some watches on variables you'd like to monitor.



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Louis" wrote:

How can one follow follow the step-by-step execution of
a
macro.

Thanks



.


--

Dave Peterson