Viewing what the Macro's doin??

dba1977 · #1 (**permalink**) 06-16-04, 10:43

Hi,
I have a Macro which has around 1000 lines in it. I wanna see what the Macro is doing, when being RUN...I mean can I view a Macro RUN step-by-step? Please lemme know.
TIA

texasalynn · #2 (**permalink**) 06-21-04, 09:45

You could run the macro with the "Step Into"

HTH
texasalynn

pierrevbaexcel · #3 (**permalink**) 06-23-04, 09:04

Open Excel and the VBEditor (only). Right click on the status bar and select "Tile windows verticaly. In the VBEditor click within the code and then use the F8 key

shades · #4 (**permalink**) 06-23-04, 09:11

Quote:

Originally Posted by dba1977

Hi,
I have a Macro which has around 1000 lines in it. I wanna see what the Macro is doing, when being RUN...

Just a question: 1,000 lines of VBA code?

Hmmmm... I wonder if it might be better to reorganize and code in units (self-contained), which is part of the structured programming approach (see John Walkenbach, Excel 2002 Power Programming with VBA, page 213). This approach means that the VBA code is easier to build, easier to maintain, easier to trouble-shoot, and easier for someone else to come in and use, maintain, update, etc.

pierrevbaexcel · #5 (**permalink**) 06-23-04, 09:22

Call me at 1-800-501-6760

I am old too

Internet Services

Web Development

Digital Marketing

Consumer Tech