Objects/properties that don't trigger the intellisense
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.
--
HTH...
Jim Thomlinson
"Conan Kelly" wrote:
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
---------------------------
"Smokin' weed kills your brain cells. Drinkin' only screws up your
liver...ya got 2 a those."
- Earl Hickey (NBC's "My Name is Earl")
|