PDA

View Full Version : move to end of the procedure



mg25683
02-02-2020, 08:16 AM
Hi,

is there a shortcut/util/smart way to move the cursor to the end of procedure?
I mean the equivalent of right clicking end sub/function>set next statement

snb
02-02-2020, 08:38 AM
Ctrl-down

mg25683
02-02-2020, 10:51 AM
nope, not even close

Paul_Hossler
02-02-2020, 02:00 PM
Hi,

is there a shortcut/util/smart way to move the cursor to the end of procedure?
I mean the equivalent of right clicking end sub/function>set next statement


Doesn't seem to be

https://bettersolutions.com/vba/visual-basic-editor/shortcut-keys.htm


Closest seems to be




Ctrl + Page Up
Moves to the top of the current procedure.


Ctrl + Page Down
Moves to the start of the next procedure.






Ctrl + Up Arrow
Moves to the sub or function directly above.


Ctrl + Down Arrow
Moves to the sub or function directly below.

p45cal
02-02-2020, 03:24 PM
nope, not even closeOh it is close, it moves the cursor one line into the next sub below.

mg25683
02-03-2020, 04:31 AM
nope, it just moves the cursor, doesn't set next statement

Paul_Hossler
02-03-2020, 06:36 AM
If you put the cursor on "End Sub" or any other line, and Ctrl-F9 it sets that line for execution without executing any intervening statements

25910

Ex.


1. Put cursor inside macro
2. F8 3 times to execute the Hello1 line
3. Put cursor on Hello7 line
4. Ctrl-F9

mg25683
02-04-2020, 02:35 PM
I asked about shortcut equivalent of moving cursor to the end of procedure and setting next statement and your solution is "move the cursor to the end of procedure and hit 'set next statement' + some extra steps " xD

Thank you cpt Obvious

p45cal
02-04-2020, 03:14 PM
I asked about shortcut equivalent of moving cursor to the end of procedure and setting next statement and the answer was:
Doesn't seem to beThe rest were suggestions that might help you.



your solution is "move the cursor to the end of procedure and hit 'set next statement' + some extra steps " xD
Thank you cpt ObviousDon't be so effing rude.
Don't like it? You know where you can go.

Paul_Hossler
02-04-2020, 03:53 PM
I asked about shortcut equivalent of moving cursor to the end of procedure and setting next statement and your solution is "move the cursor to the end of procedure and hit 'set next statement' + some extra steps " xD

Thank you cpt Obvious



I mean the equivalent of right clicking end sub/function>set next statement

Sorry

Right clicking moves the cursor and the shortcut key is Ctrl-F9

Don't know about and extra steps

However, ....

Call (800) 642 7676 and ask for Bill G.

He's waiting for your call

snb
02-05-2020, 01:11 AM
Or lit a candle to the Virgin Mary (seems to be a panacea in Poland).

mg25683
02-08-2020, 03:11 AM
Or lit a candle to the Virgin Mary (seems to be a panacea in Poland).

I will first try calling Bernie and asking him to propose some state level regulations of this matter (seems what young leftists believe to be panacea in US) xD