Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is there an auto complete shortcut in VBA?

Tags:

excel

vba

I am pretty sure there is an auto complete feature in the Excel/VBA editor but can't seem to find it. (e.g. Ctrl+Space in Eclipse).

Or am I dreaming it ?

like image 980
BuZz Avatar asked Oct 02 '12 12:10

BuZz


1 Answers

There is, and it's Ctrl+Space.

If you press that and auto complete does not happen, then there are multiple possible choices and you are presented with them.

At this point, you can navigate through the options using the arrow keys and and then press Tab to select your choice.

Also see Is there a way to get full IntelliSense for VBA in Access and Excel 2007?, which is almost a duplicate.

like image 90
GSerg Avatar answered Nov 13 '22 09:11

GSerg