Using the Object Browser

The VBE includes another tool, known as the Object Browser. As the name implies, this tool lets you browse through the objects available to you. To access the Object Browser, press F2 when the VBE is active (or choose ViewOObject Browser). You see a window like the one shown in Figure 4-3.

Figure 4-3:

Browsing for objects with the Object Browser.

Figure 4-3:

Browsing for objects with the Object Browser.

The drop-down list at the top contains a list of all currently available object libraries. Figure 4-3 shows All Libraries. If you want to browse through Excel's objects, select Excel from the drop-down list.

The second drop-down list is where you enter a search string. For example, if you want to look at all Excel objects that deal with links, type link into the second field and click the Search button. (It has a pair of binoculars on it.) The Search Results window displays everything in the object library that contains the text link. If you see something that looks like it may be of interest, press F1 for more information.

Was this article helpful?

0 0

Post a comment