Well there ya go

[Johnny C]

I've been writing Excel macros since Excel v2 (1991?) 27 years, and I only just discovered ctrl+shift to autocomplete a variable name etc.

OK I know it's only been relevant since VBA appeared but that must still be 20 years+ ... the amount of time I've wasted scrolling to the Dim and copy/pasting it.

Are there any other handy shortcuts like that?

 

[RoryA]

Doesn't do that for me. Ctrl+Shift doesn't do anything. Ctrl+j and then shift would work.

 

[Johnny C]

Lol I got trigger happy.
It's ctrl+Space and has to be at the start of a row.
Ctrl+j works (no shift) and does it mid-row which is even better, cheers!

 

[Norie]

Johnny

What do you mean 'midrow'?

CTRL+SPACE should work anywhere.

 

[RoryA]

FWIW, you'll see these shortcuts listed when you dropdown the menus in the VBE.

 

[Johnny C]

It's a minor distinction and only rarely an issue I guess but if you've got a variable declared and there's nothing with a longer version of the name e.g. you've got X declared, ctrl-shift assumes that's what you want and does nothing if the cursor is in the word just jumps to the end. If you had X and XX it would bring the list up. Ctrl-j offers a list even if the variable name is declared and is not a shorter version of anything else. One is autocomplete, one is List Objects, both useful at different times.

I can't ever recall looking at the edit menu. I've just seen outdent which I also wish I'd found years ago. Doh!

 

[My Aswer Is This]

Ctrl+Space works for me. A new trick I never knew about.
Using Excel 2013