OFF2000: Programming Resources for Visual Basic for Applications

This article was previously published under Q296498
This article has been archived. It is offered "as is" and will no longer be updated.
NOTE: For a version of this article for Microsoft Office 97 for Windows and Office 98 Macintosh Edition, please see the following article in the Microsoft Knowledge Base:
163435 VBA: Programming Resources for Visual Basic for Applications
Summary
This article lists some of the resources that are available to help youlearn Microsoft Visual Basic for Applications programming. The articlecontains the following categories:

  • Online Help
  • Use the Object Browser
  • Microsoft Press and Third-Party Reference and Learning Materials
  • Microsoft Knowledge Base on the World Wide Web
  • Helpful Knowledge Base Articles
  • Internet Newsgroups
  • Other Web Resources
More information

Online Help

For online help, do any of the following:
  • Use the Microsoft Excel Office Assistant. On the Help menu, click Microsoft Excel Help. In the Assistant balloon, type the name of an object, method, or property, and then click Search.
  • Use the Visual Basic Office Assistant. On the Help menu, click Microsoft Visual Basic Help. In the Assistant balloon, type the name of an object, method, or property, and then click Search.
  • Press F1. Double-click a word in the module sheet, and then press F1 to open Help for that object, method, or property.

Use the Object Browser

The Object Browser allows you to browse through all available objects in your project and see their properties, methods, and events. In addition, you can see the procedures and constants that are available from object libraries in your project. You can easily display online Help as you browse. You can use the Object Browser to find and use objects that you create, as well as objects from other programs.

For more information about the Object Browser, click Microsoft Visual Basic Help on the Help menu, type object browser in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

To navigate the Object Browser, follow these steps:
  1. Activate a module.
  2. On the View menu, click Object Browser (or press F2), or click Object Browser on the toolbar.
  3. Select the name of the project or library that you want to view in the Project/Library list.
  4. In the Class list, select the class. In the Member list, select specific members of your class or project.
  5. View information about the class or member that you selected in the Details section at the bottom of the window.
  6. Use the Help button to display the Help topic for the class or member that you selected.

Microsoft Press and Third-Party Reference and Learning Materials

Microsoft provides third-party contact information to help you find technical support. This contact information may change without notice. Microsoft does not guarantee the accuracy of this third-party contact information.
   Microsoft Office   ----------------   Title:     Microsoft Office 2000/Visual Basic Language Reference   Author:    Microsoft Corporation   Publisher: Microsoft Press   Date:      May 7, 1999   ISBN:      1-57231-955-0   Pages:     7040   Disk:      N/A   Web Site:  http://mspress.microsoft.com/books/2321.htm   Title:     Microsoft Office 2000/Visual Basic Programmer's Guide   Author:    David Shank, Mark Roberts, Tamra Myers   Publisher: Microsoft Press   Date:      May 7, 1999   ISBN:      1-57231-952-6   Pages:     976   Disk:      1 CD   Web Site:  http://mspress.microsoft.com/books/2320.htm   Microsoft Access   ----------------   Title:     Microsoft Access 2000/Visual Basic for Applications              Fundamentals   Author:    Evan Callahan   Publisher: Microsoft Press   Date:      May 7, 1999   ISBN:      0-7356-0592-0   Pages:     384   Disk:      1 CD   Web Site:  http://mspress.microsoft.com/books/2533.htm   Title:     Microsoft Office 2000/Visual Basic Language Reference   Author:    Microsoft Corporation   Publisher: Microsoft Press   Date:      May 7, 1999   ISBN:      1-57231-955-0   Disk:      N/A   Web Site:  http://mspress.microsoft.com/books/2321.htm   Title:     Running Microsoft Access 2000   Author:    John Viescas   Publisher: Microsoft Press   Date:      May 7, 1999   ISBN:      1-57231-934-8   Pages:     1072   Disk:      1 CD   Web Site:  http://mspress.microsoft.com/books/2049.htm   Microsoft Excel   ---------------   Title:     Running Microsoft Excel 2000   Author:    Mark Dodge and Craig Stinson   Publisher: Microsoft Press   Date:      May 7,1999   ISBN:      1-57231-935-6   Pages:     1024   Disk:      N/A   Web Site:  http://mspress.microsoft.com/books/2050.htm   Title:     Microsoft Excel 2000/Visual Basic for Applications              Fundamentals   Author:    Reed Jacobson   Publisher: Microsoft Press   Date:      May 7, 1999   ISBN:      1-7356-0593-9   Pages:     368   Disk:      1 CD   Web Site:  http://mspress.microsoft.com/books/2534.htm   Title:     Microsoft Office 2000/Visual Basic Language Reference   Author:    Microsoft Corporation   Publisher: Microsoft Press   Date:      May 7, 1999   ISBN:      1-57231-955-0   Pages:     7040   Disk:      N/A   Web Site:  http://mspress.microsoft.com/books/2321.htm   Microsoft Outlook   -----------------   Title:     Microsoft Office 2000/Visual Basic Language Reference   Author:    Microsoft Corporation   Publisher: Microsoft Press   Date:      May 7, 1999   ISBN:      1-57231-955-0   Pages:     7040   Disk:      N/A   Web Site:  http://mspress.microsoft.com/books/2321.htm   Title:     Running Microsoft Outlook 2000   Author:    Alan Neibauer   Publisher: Microsoft Press   Date:      May 7, 1999   ISBN:      1-57231-939-9   Pages:     752   Disk:      NA   Web Site:  http://mspress.microsoft.com/books/2052.htm   Microsoft PowerPoint   --------------------   Title:     Microsoft Office 2000/Visual Basic Language Reference   Author:    Microsoft Corporation   Publisher: Microsoft Press   Date:      May 7, 1999   ISBN:      1-57231-955-0   Pages:     7040   Disk:      N/A   Web Site:  http://mspress.microsoft.com/books/2321.htm   Microsoft Word   --------------   Title:     Running Microsoft Word 2000   Author:    Charles Rubin   Publisher: Microsoft Press   Date:      May 7,1999   ISBN:      1-57231-943-7     Pages:     960   Web Site:  http://mspress.microsoft.com/books/2054.htm   Microsoft Visual Basic   ----------------------   Title:     Microsoft Office 2000/Visual Basic Language Reference   Author:    Microsoft Corporation   Publisher: Microsoft Press   Date:      May 7, 1999   ISBN:      1-57231-955-0   Pages:     7040   Disk:      N/A   Web Site:  http://mspress.microsoft.com/books/2321.htm   Title:     Programming Microsoft Outlook and Microsoft Exchange   Author:    Thomas Rizzo   Publisher: Microsoft Press   Date:      June 7, 2000   ISBN:      0-7356-1019-3   Includes:  1 CD   Web Site:  http://mspress.microsoft.com/books/4352.htm				

Microsoft Knowledge Base on the World Wide Web

Many articles in the Microsoft Knowledge Base contain sample code for common Visual Basic for Applications solutions. The advantage of accessing the articles online is that you can copy the code from your browser and paste it into a module. This saves you the time it would take to manually type the code.

To access the Microsoft Knowledge Base on the World Wide Web, visit the following Microsoft Web site:For additional information about how to use the Microsoft Knowledge Base, click the article number below to view the article in the Microsoft Knowledge Base:
129725 Obtaining Knowledge Base Articles on the World Wide Web

Helpful Knowledge Base Articles

The following articles answer some frequently asked questions and can helpyou get started in developing your custom solutions in Visual Basic forApplications. To obtain any of these articles, search on the Q number (theidentification number or ARTICLE-ID number) that is associated with each ofthe articles. If you are viewing this article online, the ARTICLE-ID number is a hyperlink to the article.

Microsoft Office

222791PPT2000: PPT2000: Sample Code to Get Input from an Office Assistant Balloon
253235FILE: OFFAUTMN.EXE Discusses Office 97 and 2000 Automation and Provides Sample Code
210143ACC2000: Tips for Debugging Visual Basic for Applications Code
212673WD2000: Troubleshooting Variables and Data Types

Microsoft Access

210271ACC2000: Sending the Current Record to Word 2000 with Automation
209811ACC2000: Tips on How to Troubleshoot Microsoft Access Macros
210111ACC2000: Using Microsoft Access as an Automation Server
210588ACC2000: How to Parse Comma-Separated Text into Multiple Fields

Microsoft Excel

213578XL2000: How to Assign a Macro to an ActiveX Worksheet Control
211563XL2000: How to Create an Add-in File
213550XL2000: Sample Macros for Customizing Menus and Submenus
213763XL2000: How to Programmatically Create a Collection

Microsoft Outlook

209963ACC2000: How to Use Automation to Add Appointments to Microsoft Outlook
209955ACC2000: How to Use Automation to Create a New Contact Item in Microsoft Outlook
209948ACC2000: How to Use Automation to Send a Microsoft Outlook Message

Microsoft PowerPoint

222771PPT2000: Introduction to Macro Programming in PowerPoint 2000
222758PPT2000: How to Use the Presentations.Open Method
222790PPT2000: Sample Code to Display the Selection Type
222768PPT2000: Sample Code to Assign a Random Animation to All Objects

Microsoft Word

212682WD2000: VBA Macro Examples to Insert Text into a Document
212710WD2000: Retrieving Settings from Word Dialog Boxes Using OLE
201950WD2000: Sample Code to Scroll to Top or Bottom of Document Window

Internet Newsgroups

Click the following link for a list of peer-to-peer newsgroups thatare available to help you interact with other users of Visual Basic for Applications:For more information about Microsoft Internet newsgroups, please visit thefollowing Microsoft World Wide Web site:

Other Web Resources

The following Web sites are also of interest to Visual Basic forApplications programmers:
xl2000 wd2000 acc2000 vba2000 OFF2000 ppt2000 vba vbe vb
Properties

Article ID: 296498 - Last Review: 10/25/2013 23:39:00 - Revision: 6.0

  • Microsoft Excel 2000 Standard Edition
  • Microsoft Access 2000 Standard Edition
  • Microsoft Outlook 2000 Standard Edition
  • Microsoft PowerPoint 2000 Standard Edition
  • Microsoft Word 2000
  • kbnosurvey kbarchive kbinfo kbpending kbprogramming KB296498
Feedback