The Ultimate Reference to All Objects Methods Properties

In the Visual Basic Editor, press F2 to open the Object Browser (see Figure 2.40). The Object Browser lets you browse and search the entire Excel object library. I own a thick book that is a reprint of this entire object model from the object browser. It took up 409 pages of text. I've never used those 409 pages, because the built-in Object Browser is far more powerful and always available at the touch of F2. I'll take a few pages to teach you how to use the Object Browser.

Figure 2.40

Press F2 to display the Object Browser.

Figure 2.40

Press F2 to display the Object Browser.

Press F2 and the Object Browser appears where the code window normally appears. The topmost drop-down currently shows <All Libraries>. There is an entry in this dropdown for Excel, Office, VBA, each workbook that you have open, plus additional entries for anything that you check in Tools, References. Go to the drop-down and select only Excel for now.

In the left pane of the Object browser is a list of all classes available for Excel. Click on the Application class in the left pane. The right pane adjusts to show all properties and methods that apply to the Application object (see Figure 2.41). Click on something in the right pane like ActiveCell. The bottom pane of the object browser tells you that ActiveCell is a property that returns a Range. It tells you that ActiveCell is read only—an alert that you can not assign an address to ActiveCell to move the cell pointer.

Figure 2.41

Select a class then a member.The bottom pane tells you the basics about the particular member.Methods appear as green books with speed lines. Properties appear as index cards with a hand pointing to them.

Figure 2.41

Select a class then a member.The bottom pane tells you the basics about the particular member.Methods appear as green books with speed lines. Properties appear as index cards with a hand pointing to them.

0 0

Post a comment