VBA: show intellisense without pressing Ctrl+Space?

Question

I've had a good search if this is possible and I doubt it but can anyone confirm: is there any way to have the IDE provide intellisense in the same way as say Visual Studio in the .Net family i.e. it's automatic, no need to press Ctrl+Space for a new item?

The object.period functionality is fine but it would be great if it could for example predict which of your variables you want next, so If I dim a recordset called rst and start typing "Set" then a list of declared objects would show, including rst, again, just like in .Net. Thanks.

Where are you writing the VBa? In VS, Excel, Notepad? I assume Excel, but need to make sure — Dave, Jan 05 '17 at 11:46
Supposing you use VBA in any office product the answer is probably no. (If that would be an opportunity I think it would have been switched on by default). — Máté Juhász, Jan 05 '17 at 11:59
@ Dave, sorry yes I was referring to the IDEs in Excel, Access and the like. — Absinthe, Jan 05 '17 at 12:09
Visual Studio is *a lot* more advanced than VBE. You can only get intellisense for the VBA Object Model, nothing user defined unless it's a class. — Raystafarian, Apr 20 '17 at 19:58

score 0 · Answer 1 · answered Mar 14 '18 at 15:47

0

Sadly, this functionality doesn't exist (perfectly) within the native VBA IDE.

Some people report checking "Auto List Members" in Tools > Options helps.

answered Mar 14 '18 at 15:47

wizlog

13,277
24
77
116

VBA: show intellisense without pressing Ctrl+Space?

1 Answers1