How to Find Visual Basic for Applications Help (142128)

MORE INFORMATION

There are a number of resources available that provide both explanations of syntax and examples of Visual Basic for Applications code. Some of these resources include Microsoft Excel Help files, the Object Browser, and Knowledge Base articles.

Using the Help Files in Microsoft Excel

Method 1: Method 2: Method 3: Method 4:

Object Browser

The Object Browser is a great place to look for methods and properties that apply to a particular object. To use the Object Browser you must be on a module sheet. On the view menu click Object Browser. Set the library to Microsoft Excel and select any object from the object/modules list to see methods and properties that apply to it. The question mark button opens the Help file for the selected item.

In Addition, both Excel 97 and Excel 98 provide a search feature that allows you to search for an object, method, or property in a single library or in all the Visual Basic object libraries.

To use this search feature, follow these steps:

1. In a module sheet, click Object Browser on the View menu.
2. In the first box, click the library in which to search or click <All Libraries> to search in all the Visual Basic object libraries.
3. In the second box, type the name of the object, method, or property for which you are searching.
4. Click the binocular icon or press the ENTER key.

Knowledge Base Articles

The following sections explain how to access the Microsoft Knowledge Base on the World Wide Web, The Microsoft Network, and other online services. The Microsoft Knowledge Base includes thousands of articles that answer common questions about using Microsoft Excel.

The Internet

The Microsoft World Wide Web server, named www.microsoft.com, contains information on Microsoft products. To access the Microsoft Knowledge Base on the World Wide Web:

1. Connect to the Knowledge Base using the address:

   http://www.microsoft.com/support

2. Click the Support Online hyperlink.

For additional information, please see the following article in the Microsoft Knowledge Base:

The Microsoft Network

To access the Microsoft Knowledge Base on The Microsoft Network:

1. On the Edit menu, click Go To.
2. Click Other Location.
3. When the prompt "Type a Go word for a particular service" appears, type mssupport.

NOTE: It may take a minute or more for the Knowledge Base to appear while it prepares the necessary files to run.

Other Online Services

To access the Microsoft Knowledge Base on other online services, use the Internet address discussed in "The Internet" section in this article.

Creating Shortcuts

In Microsoft Windows 95, you can create a shortcut to the Microsoft Knowledge Base so that each time you click the shortcut icon, the Knowledge Base appears.

To place a shortcut on the desktop, follow these steps:

1. After you access the Knowledge Base using the instructions earlier in this article, click the KB icon.
2. On the File menu, click Create Shortcut.

To change any settings for the shortcut, such as what kind of window it starts in or what key combination is used to access it, right-click the shortcut, and then click Properties.

To delete a shortcut, drag it to the Recycle Bin.

Reference Books

The following is a list of books that provide assistance with Visual Basic for Applications code: Microsoft Press books can be found in bookstores everywhere, or you can order direct by calling (800) MSPRESS. In Canada, call (416) 293-8464, extension 340.

If you are outside the United States, contact the Microsoft subsidiary for your area. To locate your subsidiary, see the Microsoft World Wide Offices Web site at: