This sounds like BASIC, so why doesn't it look familiar?

Object Browser: The ultimate reference

In the VB Editor, press F2 to open the Object Browser, which lets you browse and search the entire Excel object library. The built-in Object Browser is always available; you simply press the F2 key. The next few pages show you how to use it.

By default, the Object Browser opens where the code window normally appears. However, you can resize the window and reposition it anywhere you like, including on another monitor.

The topmost dropdown currently shows <All Libraries>. There are entries in this dropdown for Excel, Office, VBA, and each workbook that you have open, plus additional entries for anything you check in Tools | References. For now, go to the dropdown and select Excel.

In the bottom-left window of the Object Browser is a list of all classes available for Excel (see Figure 2-16). Click the Application class in the left window. The right window adjusts to show all properties and methods that apply to the Application object. Click something in the right window, such as ActiveCell. The bottom window of the Object Browser tells you that ActiveCell is a property that returns a range. It also tells you that ActiveCell is read-only (an alert that you cannot assign an address to ActiveCell to move the cell pointer).

FIGURE 2.16 The Object Browser lets you explore objects, properties, methods, constants, and enumerations available in the VBA environment.

You have learned from the Object Browser that ActiveCell returns a range. When you click the hyperlink for Range in the bottom window, the Classes and Members windows update to show you all the properties and methods that apply to Range objects and, hence, to the ActiveCell property. Click any property or method and then click the yellow question mark near the top of the Object Browser to go to the online Help topic for that property or method.

Type any term in the text box in the Search field (next to the binoculars) and press Enter to find all matching members of the Excel library. Methods appear as green books with speed lines. Properties appear as index cards, each with a hand pointing to it.

The search capabilities and hyperlinks available in the Object Browser make it much more valuable than an alphabetic printed listing of all the information. Learn to make use of the Object Browser in the VBA window by pressing F2. To close the Object Browser and return to your code window, click the X in the upper-right corner.