Run Intellisense constantly in VBA

[jantokus]

I would like VBA to automatically list the available objects/properties/methods as I write (i believe this is called Intellisense). However, after every line, I have to activate it again by pressing Ctrl-j. How can I make it run constantly? Thanks a lot in advance.

Jan

 

[actualDOOD]

It seems like yesterday..

 

[ChelShay]

Yes I am replying to a post in 2006 also... Run Intellisense constantly in VBA

Thank You, I'm following a video and the Intellisense didn't activate looked around so many complicated solutions, followed your instructions, only thing was I closed and re-opened and it worked perfectly, so again, thanks!

While in the VBE, click Tools > Options > Editor tab.

Place a checkmark next to
"Require Variable Declaration" (always a good idea)
and
"Auto List Members"

Click OK to exit the Options dialog.