Menu
In VB.NET, the IntelliSense pops up as soon as you start typing which gives you a pretty full list of things you can use at that moment. The IntelliSense in VBA however, doesn't kick on for me until a period is put after the part you're using. For example, I go into the VBA editor in Excel 2007 and start typing the word "Range" but the IntelliSense doesn't come up until I type "Range." after which it will give me a list of things I can use at that point.
Is there any way to make IntelliSense come up sooner in the VBA editor, so that I'm able to see a list of things that can be used like Davg, DCount, etc?
593
The Ctrl + Space Keyboard Shortcut In the VB Editor, you can begin to type any word, reference, or variable and then press Ctrl + Space to bring up the Intellisense menu.
Intellisense is basically auto-completion when you are typing. This displays a short description of member, function, arguments etc next to the cursor and is a convenient way to access functions, parameters, enumerations etc. Using intellisense speeds up development by reducing keyboard input.
Just press Ctrl + Space at any time in the editor.
79
No, but you can type Excel first. Put a period after that, and you'll find out more than you ever wanted to know about Excel.
Same with Access. Type Access and a period, and you will find DCount there.
38
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
