PDA

View Full Version : What's the Name of that?



prabhafriend
01-05-2010, 07:18 AM
What is the name list in which we get the sub-objects, methods, properties of an object whenever we type an object name and put “.” Following it? Anyway my question is why don’t I see it for all the objects and all the time. If suppose I type Activesheet. Directly it wont lists but for excel.activesheet works. I want to understand this. Kindly help.

CreganTur
01-05-2010, 02:12 PM
What you're talking about is Intellisense. It will show you the properties and methods available to an object or the parameters for a method.

Bob Phillips
01-05-2010, 03:16 PM
Activesheet is part of the sheets collection, which can be worksheets, chart sheets and so on. Intellisesense has to get its info from the relevant type library for that particular object type. If the object type is not discernible, it is not possible.