4.2. Using the Object Browser

The Object Browser is probably one of the most powerful tools you'll use when writing VBA code. Display it in the VBA Editor by selecting View Object Browser or by clicking F2. The Object Browser, shown in Figure 4-2, has a number of components.

When you load the Object Browser, you can still view the Project Explorer and the Properties window. The Object Browser appears directly over the Code window. You can return to the Code window at any time by selecting View Code. If multiple code windows are open, you can choose Window from the menu and then select the code window that you want, or you can move the cursor to the code window by clicking on F7. The following are some of the Object Browser's components that you'll use most often:

  • The Project/Library box: Shows all the available type libraries. You can choose All Libraries or any available type library from the drop-down box. The type library you choose dictates which objects you can browse with the Object Browser. Later in this chapter, you'll see how to add a type library to your Project.

  • The Search box: Enter search terms and click the Search button (the binoculars icon) to search the selected type libraries for the particular term. Results of your search are displayed in the Search Results pane. ...

Get Access™ 2007 VBA Programmer's Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.