Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Darkest Kent, UK., Kent, England
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Another no-brainer (Excel/VBA)

    Here's my next one:

    When 'stepping into' a macro in the editor, is there a way to make the yellow arrow appear at the cursor position or do I really have to go all the way up to the top of the Sub and drag it down to where I want to start stepping?

    Tks.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Another no-brainer (Excel/VBA)

    Select the line in the code where you want to start stepping and either left-click in the gray bar to the left of the code line or just hit F9. Either one will set a breakpoint on that line. Then when you run the code, it will break on that line and wait for you to hit F8 to advance to the next line or F5 to continue or to select "Run to Cursor" (Ctl+F8) if you want to run just short bits of code to see what's happening.
    Charlotte

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Flims, Switzerland
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Another no-brainer (Excel/VBA)

    place your cursor and press Ctrl+F9

  4. #4
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Darkest Kent, UK., Kent, England
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Another no-brainer (Excel/VBA)

    That's the one.

    Tks.

Posting Permissions

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