VBA - Intellisense

Hello all!

Newbie VBA writer here. And, I'm just wondering....

Are there specific rules as to why & when Intellisense will not be available when writing VBA?


I already know that for Intellisense to work for variables, you need to declare them, and have Option Explicit enabled.

But, there are sometimes, where I'll be writing a line of code, and I'll start typing, "Act" (to start writing "Activate"), press Ctrl+Space, and Intellisense will not be available. Why is this?


Thank you!!
Robert

In VBA editor, try to check by:
Tools/Option-> tab Editor, make sure the box "Auto List Members" is checked.
If it still does not work, in edit mode, hit "Ctrl + Space" to activate

Intellisense will only work if it knows what type of object is involved. Any time you have an object that is just of generic Object type, you won't get intellisense. For example, activesheet returns an object, not a specific type, so you won't get intellisense. Similarly, using Worksheets() actually returns an Object, not a Worksheet.