Info

We have learned from the Object Browser that ActiveCell returns a range. Click the green hyperlink for Range in the bottom pane and you will see all the properties and methods that apply to Range objects and hence to the ActiveCell property. Click on any property or method and click the yellow question mark near the top of the Object Browser to go to the help topic for that property or method.

Type any term in the text box next to the binoculars and click the binoculars to find all matching members of the Excel library.

The search capabilities and hyperlinks available in the Object Browser make it far more valuable than an alphabetic printed listing of all of the information. Learn to make use of the Object Browser in the VBA window by using F2. To close the object browser and return to your code window, click on the lower X in the upper-right corner (see Figure 2.42).

Figure 2.42

Close the Object Browser and return to your code window by clicking this X.

Figure 2.42

Close the Object Browser and return to your code window by clicking this X.

0 0

Post a comment