Watching a macro execute itself line by line.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to debug a long macro that I have recorded
I would like to be able to see it execute each instruction or line one by one

I'm totally new to Vba and I would gratefully appreciate step by step instructions

Thanks in advance
 
Start macro running vrom VB editor with the F8 button or
insert the command STOP at whatever point you wish to step from then
press F8 to step one through each command
 
You can size your workbook and VB Editor screens so that both are
visible at the same time. Click in your macro in the editor and
repeatedly press your F8 key, or click on the "Step into" button to
see each line of your code execute.

You can use Debug/Toggle Breakpoint on a line or type "Stop" in a line
on its own to run the macro automatically to that line so you can step
from there.

There are other facilities too. I suggest you explore the menus and
buttons.

Regards
BrianB
===========================================
 
Back
Top