Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Location
    Kalamazoo
    Posts
    42

    Question Unanswered: Viewing what the Macro's doin??

    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

  2. #2
    Join Date
    Jun 2002
    Location
    Houston, TX
    Posts
    116
    You could run the macro with the "Step Into"

    HTH
    texasalynn

  3. #3
    Join Date
    Dec 2003
    Location
    Ottawa, Canada
    Posts
    72

    Talking Viewing what the macro does

    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
    A piece of data is like a brick
    If you don't build anything with it
    It is just a brick
    www.excel-examples.com

  4. #4
    Join Date
    Oct 2003
    Posts
    1,091
    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.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  5. #5
    Join Date
    Dec 2003
    Location
    Ottawa, Canada
    Posts
    72

    Seeing what it does

    Call me at 1-800-501-6760

    I am old too
    A piece of data is like a brick
    If you don't build anything with it
    It is just a brick
    www.excel-examples.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •