Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    London, Gtr London, England
    Posts
    357
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Tracking program progress (XP 2003)

    Is there any way I can see the program step through a spreadsheet? Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Tracking program progress (XP 2003)

    Please provide some details.

  3. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    London, Gtr London, England
    Posts
    357
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tracking program progress (XP 2003)

    The program I have picks-up values enterred in cells multiples the values and pastes the results in cells. Thr results I obtained are incorrect and I would like to see the cells displayed as the program runs ie is it possible to 'step through' and see what is is being picked-up?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Tracking program progress (XP 2003)

    You can single-step through a macro as follows:
    - Select Tools | Macro | Macros...
    - Select the macro you want to run.
    - Click 'Step Into'.
    - Press F8 to execute a single instruction.
    - You can switch back and forth between the Visual Basic Editor and Excel (or arrange them side by side)
    - You can inspect the values of variables by hovering the mouse pointer over them in the code.

  5. #5
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    London, Gtr London, England
    Posts
    357
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tracking program progress (XP 2003)

    Thankks for the prompt reply. How can I arrange for the screens to be side-by-side?

    Farmer

  6. #6
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    London, Gtr London, England
    Posts
    357
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tracking program progress (XP 2003)

    Soory, ignore, as I figured it out - drag the edge of the window.

Posting Permissions

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