List of programming resources for Visual Basic for Applications

Article translations Article translations
Article ID: 305326 - View products that this article applies to.
This article was previously published under Q305326
For a Microsoft Office 2000 version of this article, see 226118.
For a Microsoft Office 97 and Microsoft Office 98 Macintosh Edition version of this article, see 163435.
Expand all | Collapse all

On This Page

Summary

This article lists some of the resources that are available to help you learn Microsoft Visual Basic for Applications programming. The article contains the following categories:
  • Online Help
  • The Object Browser
  • Microsoft Press and third-party reference and learning materials
  • Microsoft Knowledge Base on the World Wide Web
  • Helpful Knowledge Base articles
  • Other Web resources

More information

Online Help

  • 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.
  • F1: Select 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.

You can get help for the Object Browser by searching for Object Browser in Help.

To navigate the Object Browser, follow these steps:
  1. Activate a module.
  2. On the View menu, click Object Browser (F2). Or, click Object Browser on the Standard toolbar.
  3. In the Project/Library list, select the name of the project or library that you want to view.
  4. In the Class list, select the class. Use the Member list to 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. Click Help on the Standard toolbar 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 XP
   -------------------

   Title:     Microsoft Office XP Developer's Guide
   Author:    Microsoft Corporation
   Publisher: Microsoft Press
   Date:      March 28, 2001
   ISBN:      0-7356-1242-0
   Pages:     816
   Disk:      1 CD
   Web Site:  http://www.microsoft.com/mspress/books/4846.asp

   Title:     Microsoft Office XP Inside Out
   Author:    Michael Halvorson and Michael J. Young
   Publisher: Microsoft Press
   Date:      May 9, 2001
   ISBN:      0-7356-1277-3
   Pages:     1632
   Disk:      1 CD
   Web Site:  http://www.microsoft.com/mspress/books/3229.asp

   Microsoft Excel 2002
   --------------------

   Title:     Microsoft Excel Version 2002 Inside Out
   Author:    Mark Dodge and Craig Stinson
   Publisher: Microsoft Press
   Date:      May 9, 2001
   ISBN:      0-7356-1281-1
   Pages:     1104
   Disk:      1 CD
   Web Site:  http://www.microsoft.com/mspress/books/5020.asp

   Microsoft FrontPage 2002
   ------------------------

   Title:     Microsoft FrontPage Version 2002 Inside Out
   Author:    Jim Buyens
   Publisher: Microsoft Press
   Date:      May 2, 2001
   ISBN:      0-7356-1284-6
   Pages:     1264
   Disk:      1 CD
   Web Site:  http://www.microsoft.com/mspress/books/5023.asp

   Microsoft Outlook 2002
   ----------------------

   Title:     Building Applications with Microsoft Outlook Version 2002
   Author:    Randy Byrne
   Publisher: Microsoft Press
   Date:      July 25, 2001
   ISBN:      0-7356-1273-0
   Pages:     944
   Disk:      1 CD
   Web Site:  http://www.microsoft.com/mspress/books/4999.asp

   Title:     Microsoft Outlook Version 2002 Inside Out
   Author:    Jim Boyce
   Publisher: Microsoft Press
   Date:      June 20, 2001
   ISBN:      0-7356-1282-X
   Pages:     1264
   Disk:      1 CD
   Web Site:  http://www.microsoft.com/mspress/books/5021.asp

   Microsoft Word 2002
   -------------------

   Title:     Microsoft Word Version 2002 Inside Out
   Author:    Mary Millhollon and Katherine Murray
   Publisher: Microsoft Press
   Date:      June 20, 2001
   ISBN:      0-7356-1278-1
   Pages:     1184
   Disk:      1 CD
   Web Site:  http://www.microsoft.com/mspress/books/5019.asp

				

Microsoft Knowledge Base on the World Wide Web

Many articles in the 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 that is required to manually type the code.

To access the Microsoft Knowledge Base on the World Wide Web, visit the following Microsoft Web site:
http://support.microsoft.com
For more information about how to use the Microsoft Knowledge Base, click the following article number 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 help you get started in developing your custom solutions in Visual Basic for Applications. To obtain any of these articles, search on the Q number (the identification number or ARTICLE-ID number) that is associated with each of the articles. If you are viewing this article online, the ARTICLE-ID number is a hyperlink to the article.

Microsoft Office

290577 Office Assistant not answering Visual Basic for Applications questions
290140 How to run the sample code for the Office XP programs from Knowledge Base articles
287120 How to automate Excel text to speech in another Office program
287567 Considerations for disabling VBA in Office
302460 The Office XP Automation Help file is available for download

Microsoft Access

279508 How to display and use the file dialog box in Access 2002
229802 How to use SetOption to disable warning messages in an Access Application
289670 How to synchronize two combo boxes on a form in Access 2002 or in Access 2003
278378 How to use AddItem and RemoveItem to move selections from one list box to another
285822 How to determine who is logged on to a database by using Microsoft Jet UserRoster in Access 2002 or in Access 2003
290152 How to determine if a date falls on a weekend or a holiday in Access 2002
285820 How to display images from a folder in a form, a report, or a data access page
299024 How to skip used mailing labels and print duplicates in Access 2002

Microsoft Excel

291304 How to select ranges using Visual Basic for Applications (Novice examples)
213428 How to suppress "Save Changes?" prompt when you close a workbook
291323 Sample macro code to change the case of text in Excel
213566 How to create application-level event handlers
213646 How to Use the Left, Right, Mid, and Len Functions in Visual Basic
213837 How to run subroutines and macros from Visual Basic in Excel 2000 or Excel 2002

Microsoft Outlook

220595 How to automate Outlook by using Visual Basic
285202 List of Outlook object model constants
287531 List of resources for custom forms and programming with Outlook 2002
290500 Description of the developer-related e-mail security features in Outlook 2002

Microsoft PowerPoint

291926 How to use the WebBrowser control on a slide
291876 How to control a Shockwave Flash Control on a slide in PowerPoint

Microsoft Word

306258 How to create a combo box that contains more than 25 items in Word 2002
306348 How to programmatically save each page or section of a document as a separate file
306281 How to store and retrieve variables in documents
306338 Sample macro that uses a loop to find text
306248 Sample macro to list all files in a folder
291474 How to update fields in a protected form in Word 2003 and in Word 2002
306346 Sample macro to print all Word documents found in a folder

Other Web resources

The following Web sites are also of interest to Visual Basic for Applications programmers:
Microsoft Office Developer Center

Microsoft Visual Basic Web site

Microsoft Developer Network Web site

Summit Web site for Microsoft VBA

Properties

Article ID: 305326 - Last Review: November 19, 2012 - Revision: 2.0
Applies to
  • Microsoft Office XP Developer Edition
  • Microsoft Office XP Professional Edition
  • Microsoft Office XP Small Business Edition
  • Microsoft Office XP Standard Edition
  • Microsoft Access 2002 Standard Edition
  • Microsoft Excel 2002 Standard Edition
  • Microsoft FrontPage 2002 Standard Edition
  • Microsoft Outlook 2002 Standard Edition
  • Microsoft PowerPoint 2002 Standard Edition
  • Microsoft Word 2002
Keywords: 
kbhowto kbprogramming KB305326

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com