VBA macro step-by-step

[Louis]

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

Thanks

 

[keepitcool]

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]

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.

 

[Dave Peterson]

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)