Debugging macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

annep - 20 Jan 2006 21:10 GMT

I used to program in Quattro Pro a long time ago.
When I wanted to debug a Quattro Pro macro, I was able to start the
macro (I can't even remember which command that was) but then I could
hit the space bar and I could see the macro execute step by step.
Is there such a thing in excel?

Signature

annep

Reply to this Message

Gary Keramidas - 20 Jan 2006 21:15 GMT

yes, F8 will step through the code

Signature

Gary

> I used to program in Quattro Pro a long time ago.
> When I wanted to debug a Quattro Pro macro, I was able to start the
> macro (I can't even remember which command that was) but then I could
> hit the space bar and I could see the macro execute step by step.
> Is there such a thing in excel?

Reply to this Message

annep - 20 Jan 2006 21:32 GMT

I must be missing something. If I step into the macro and hit F8 it just
goes to the next line in the macro. I want to see what it is doing to
the spreadsheet?
Anne

Signature

annep

Reply to this Message

Jim Thomlinson - 20 Jan 2006 22:01 GMT

Switch back to the Excel spreadsheet and you will be able to see what is
going on in the sheets. In the Visual basic editor you can check the values
of variables and see the flow of the program as it executes.

Note: be careful when you switch to the Spreadsheet. If you move the active
cell around or change sheets the execution of the code may be effected...

Signature

HTH...

Jim Thomlinson

> I must be missing something. If I step into the macro and hit F8 it just
> goes to the next line in the macro. I want to see what it is doing to
> the spreadsheet?
> Anne

Reply to this Message

annep - 20 Jan 2006 22:18 GMT

Thank you,
Anne

Signature

annep

Reply to this Message