Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2002
    Location
    CT
    Posts
    361
    Thanks
    0
    Thanked 1 Time in 1 Post

    Pausing macros (Office XP)

    I have several macros that bring up a series of input windows. Occasionally I'll mistype an entry and would like to "go back" to that window to make the change before the sheet prints out (last command is to print).

    Is there a way to force a pause in the running of the macro so I can edit one of these cells....or even stop it and start over?

    Thanks,
    BH Davis

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

    Re: Pausing macros (Office XP)

    It depends on how much you know about your macros <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Try hitting Ctrl+Break You can select whether you want to stop macro execution (so you can modify things and run the macro again), or enter Debug mode.
    If you enter Debug mode, you can drag the execution pointer back to before you made a mistake, then press F5 to continue execution. You can also sneak back to Excel to change things before continuing execution.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2002
    Location
    CT
    Posts
    361
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Pausing macros (Office XP)

    Hans,

    THANK YOU !!!!!!!!!!!!!!!!!!!

    <CTRL><BREAK> is exactly what I was looking for. From there I can drag the yellow line indication arrow up in Visual Basic and correct the error.

    Don't ya just love the web!!!!!!!!!!!!

    Thanks again,
    BH Davis

Posting Permissions

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