View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default 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")