MSForms (used to create custom dialog boxes)

Office (objects common to all Microsoft Office applications)

Stdole (OLE automation objects)

VBA

The current project (the project that''s selected in the Project Explorer) and any workbooks referenced by that project

Your selection in this upper-left drop-down list determines what is displayed in the Classes window, and your selection in the Classes window determines what is visible in the Members Of window.

After you select a library, you can search for a particular text string to get a list of properties and methods that contain the text. You do so by entering the text in the second drop-down list and then clicking the binoculars (Search) icon. For example, assume that you''re working on a project that manipulates cell comments:

Select the library of interest. If you''re not sure which object library is appropriate,

Enter Comment in the drop-down list below the library list.

Click the binoculars icon to begin the text search.

The Search Results window displays the matching text. Select an object to display its classes in the Classes window. Select a class to display its members (properties, methods, and constants). Pay attention to the bottom pane, which shows more information about the object. You can press F1 to go directly to the appropriate help topic.