Objects/properties that don't trigger the intellisense

[Conan Kelly]

Hello all,

What is the terminology to describe the type of property/object that does
not trigger the intellisense (the properties/methods dropdowns and function
definition tooltips). For example, "Selection" vs. "ActiveCell". Selection
will not trigger the intellisense stuff, whereas ActiveCell will. (If I
remeber correctly, "ActiveSheet" will not trigger it either)

Has anyone compiled a list of all of the properties/objects that will not
trigger the intellisense?

Thanks for any help anyone can provide,

Conan Kelly

 

[Jim Thomlinson]

Intellisence will exist any time that the object can be uniquely identified.
For example Selection does not necessarly refer to a cell. It could be a
shape that was selected. The properties and methods for a shape are
completely different than they are for a cell. ActiveCell can only be a cell.
ActiveSheet could be either a worksheet or a chart sheet. Once again the
properties and methods are different.

If you want intellisence then you can do something like this
dim wks as worksheet
set wks = Activesheet

In the above example since wks is uniquely identified as a worksheet the
intellisence will work.