Objects/properties that don't trigger the intellisense

  • Thread starter Thread starter Conan Kelly
  • Start date Start date
C

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
 
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.
 
Back
Top