Locating Procedures with the Object Browser

In addition to locating objects, properties, and methods, the Object Browser is a handy tool for locating and accessing procedures written in various VBA projects. The following example demonstrates how you can see, at a glance, which procedures are stored in the Personal workbook.

1. Activate the Object Browser and select Personal from the Project/Library drop-down list.

Object Browser

HEE|

I2ZHÎQBHHH1J '11 _|_| Jj

1

3 ftl t|

. Classes

Members of'<globals>'

o ¡<gioeals>

^ For inulasOnOff ^ MoveCiicle ^ MoveTextBox ^ NewFolclei RemoveFoIifer

SJieetl Si Tiiis Workbook Manipulations .ï' Switches

Project Personal

CiTDocuments and SettihgsUuiaia KorcMpplic-awn DataMcrosoft ■

\ExcerXLSTART\PERSONAL.XLS

Figure 2-22:

The Object Browser lists all the procedures available in a particular VBA project.

Figure 2-22:

The Object Browser lists all the procedures available in a particular VBA project.

The left side of the Object Browser displays the names of objects that are included in the selected project. The list box on the right shows the names of all the available procedures.

Double-click the name of the NewFolder procedure. Visual Basic positions the cursor in the first line of the selected procedure.

Close the Object Browser window.

0 0

Post a comment