Another no-brainer (Excel/VBA)

Topic

New Reply

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.

Reply | Quote

Replies

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.

Reply | Quote

place your cursor and press Ctrl+F9

Reply | Quote

That’s the one.

Tks.

Reply | Quote