VBA intellisense Not Working

This article explains some of the common reasons why Intellisense might stop working  in the VBA Editor.


Contents

What is it?

Intellisense is the drop down list that appears next to variables in the VBA editor:
Intellisense


Reason #1:

If the following conditions are met intellisense will not work:

  • You have accidently defined 2 functions/subs with the same name
  • You have defined a variable of a non datatype value (For example Workbooks, Worksheets, Ranges, …)

Intellisense will not work for this variable.

Normal Behaviour:
Normal

Two functions/subs with the same name:
2 Functions


Reason #2:

Forgetting to add reference to objects in external libraries.

Example: Lets say we are inside the Excel VBA editor and we are trying to Automate a Word application. Without adding reference to the Word object library intellisense will not work:
Word
After adding reference intellisense will work correctly:
Reference
Result:
Result


Reason #3:

Using generic objects.

Normal object declaration:
Normal Dec

Generic object:
Generic


Reason #4:

Late binding will cause intellisense not to work. This is for the same reason as explained in the previous section. Late binding uses Generic objects.

Early Binding:
Early Binding
Late Binding:
Late Binding

If you need assistance with your code, or you are looking for a VBA programmer to hire feel free to contact me. Also please visit my website  www.software-solutions-online.com

6 thoughts on “VBA intellisense Not Working”

Leave a Reply

Your email address will not be published. Required fields are marked *