The information in this article applies to:
SUMMARYThis article describes where to find helpful resources to use when you are programming in Microsoft Excel using Microsoft Visual Basic for Applications. MORE INFORMATIONThere 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 ExcelMethod 1:If you are working in a module sheet, double-click a word on the module sheet and press F1. If you are using a Macintosh computer, press the Help key on your keyboard instead of F1. Pressing F1 or Help will run Help for that particular object, method, or property.Method 2: In Microsoft Excel version 5.x, click the Help menu, and then click contents in the drop-down list. To access the Visual Basic Reference information, click Programming With Visual Basic. Click Programming Language Summary to see an alphabetical list of objects, properties, and functions.Method 3: If you are using Microsoft Excel version 7.0 you can use the Answer Wizard.Method 4: On a module sheet in Excel 97 for Windows and Excel 98 Macintosh Edition, click Microsoft Visual Basic Help on the Help menu, type the name of the object, method, or property you want to know about, and then click the search button. Object BrowserThe 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:
Knowledge Base ArticlesThe 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 InternetThe Microsoft World Wide Web server, named www.microsoft.com, contains information on Microsoft products. The home page (or top-level display) on the server also contains pointers to ftp.microsoft.com and gopher.microsoft.com, making it an ideal entry-point to Internet services at Microsoft. To access the Microsoft Knowledge Base on the World Wide Web:
Q129725 Obtaining Knowledge Base Articles on the World Wide Web The Microsoft NetworkTo access the Microsoft Knowledge Base on The Microsoft Network:
Other Online ServicesTo access the Microsoft Knowledge Base on other online services, use the Internet address discussed in "The Internet" section in this article.Creating ShortcutsIn 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:
To delete a shortcut, drag it to the Recycle Bin. Reference BooksThe following is a list of books that provide assistance with Visual Basic for Applications code:"Microsoft Excel Visual Basic Programmer's Guide"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: http://www.microsoft.com/worldwide/default.htm Additional query words: 5.00a 5.00c xl97 8.00
Keywords : kbprg kbdta PgmHowto KbVBA |
|
Last Reviewed: October 30, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |