VBA macro step-by-step

  • Thread starter Thread starter Louis
  • Start date Start date
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 >
 
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.
 
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)
 
Back
Top