The Object Browser

The Object Browser, shown in Figure 1-26, is displayed by choosing View > Object Browser or by pressing the F2 function key. It displays the classes, properties, methods, events, and constants available from any object libraries, and it also shows the procedures in your project. You can also use it to find and use custom objects you create.

Search Results ~_

Library I Class | Member

Classes

Members of "Range"

© PivotTables

0

Activate

3

JjS- PlotArea

AddComment

1

© Point

Addlndent

1

0 Points

Ei3

Address

© Protection

Ei:]

AddressLocal

PublishObject

Ô-

AdvancedFilter

® PublishObjects

LJ

H-1

AllowEdit

® QueryTable

E§::

Application

© QueryTables

ApplyNames

©I Range

ApplyOutlineStyles

© Ranges

ILZ'

Areas

© RecentFile

Auto Complete

© RecentFiles

AutoFill

© RectangularGradien

Auto Fi Iter

© Research

AutoFit

©1 RoutingSlip

AutoOutline

@J RTD

BorderAround

Scenario

EÜ3

Borders

© Scenarios

Calculate

© Series

0

CalculateRowMajorOrder

0

Class Range

Member pf Excel

Member pf Excel

Figure 1-26. The Object Browser

Object Browser Window Elements

The Object Browser window contains window elements that enable you to search for a method or property within an object library and to get information about the selected method or property.

Project/Library Box: The Project/Library box displays the currently referenced libraries for the active project (Figure 1-27). Libraries can be added in the Tools > References dialog box. The <All Libraries> selection allows all of the libraries to be displayed at one time.

I Project/library I

Figure 1-27. The Library drop-down list box

Search Text box: This text box contains the string that you want to use in your search. You can type a string or choose the string you want from the drop-down list. The Search Text box contains the last four search strings that you entered until you close the project. You can also use the standard Visual Basic wildcards when typing a string. You can search for a whole word by using the Find Whole Word Only command from the shortcut menu.

Go Back button: This allows you to go back to the previous selection in the Classes and "Members of" lists. Each time you click it, you move back one selection.

Go Forward button: This allows you to repeat your original selections in the Classes and "Members of" lists each time you click it.

Copy to Clipboard button: This copies the current selection in the "Members of" list or the Details pane text to the clipboard.

View Definition button: This moves the cursor to the place in the code window where the selection in the "Members of" list or the Classes list is defined.

Help button: This displays the online help topic for the item selected in the Classes or "Members of" list. You can also press F1 to access this.

Search button: This searches the libraries for the class, property, method, event, or constant that matches the string you typed in the Search Text box. The result of the search is shown in the Search Results pane.

Show/Hide Search Results button: This opens or hides the Search Results pane.

Search Results list: This list displays the library, class, and member that matches the items that contain your search string.

Classes list: This list displays all of the available classes in the library or project selected in the Project/Library box.

"Members of" list: This list displays the elements of the class selected in the Classes pane by group and then alphabetically within each group.

Details pane: This pane shows the definition of the class member. The Details pane (Figure 1-28) contains a hypertext link to the class or library to which the element belongs. Some members have hypertext links to their parent class. For example, if the text in the Details pane states that TextBox1 is declared as a text box type, clicking text box takes you to the TextBox class. You can copy or drag text from the Details pane to the code window.

Figure 1-28. The Details pane

Split bar: This splits the panes so that you can adjust their size. There are split bars between the following:

• The Classes box and the "Members of" box

• The Search Results list and the Classes and "Members of" boxes

• The Classes and "Members of" boxes and the Details pane

0 0

Responses

  • raino jokihaara
    Where is the object browser office 2007?
    7 years ago

Post a comment