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
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:
Use the Object BrowserThe 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:
Microsoft Press and third-party reference and learning materialsMicrosoft 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 WebMany 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.comFor more information about how to use the Microsoft Knowledge Base, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/129725/ )Obtaining Knowledge Base articles on the World Wide Web
Helpful Knowledge Base articlesThe 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.
(http://support.microsoft.com/kb/290577/ )Office Assistant not answering Visual Basic for Applications questions
(http://support.microsoft.com/kb/290140/ )How to run the sample code for the Office XP programs from Knowledge Base articles
(http://support.microsoft.com/kb/287120/ )How to automate Excel text to speech in another Office program
(http://support.microsoft.com/kb/287567/ )Considerations for disabling VBA in Office
(http://support.microsoft.com/kb/302460/ )The Office XP Automation Help file is available for download
(http://support.microsoft.com/kb/279508/ )How to display and use the file dialog box in Access 2002
(http://support.microsoft.com/kb/229802/ )How to use SetOption to disable warning messages in an Access Application
(http://support.microsoft.com/kb/289670/ )How to synchronize two combo boxes on a form in Access 2002 or in Access 2003
(http://support.microsoft.com/kb/278378/ )How to use AddItem and RemoveItem to move selections from one list box to another
(http://support.microsoft.com/kb/285822/ )How to determine who is logged on to a database by using Microsoft Jet UserRoster in Access 2002 or in Access 2003
(http://support.microsoft.com/kb/290152/ )How to determine if a date falls on a weekend or a holiday in Access 2002
(http://support.microsoft.com/kb/285820/ )How to display images from a folder in a form, a report, or a data access page
(http://support.microsoft.com/kb/299024/ )How to skip used mailing labels and print duplicates in Access 2002
(http://support.microsoft.com/kb/291304/ )How to select ranges using Visual Basic for Applications (Novice examples)
(http://support.microsoft.com/kb/213428/ )How to suppress "Save Changes?" prompt when you close a workbook
(http://support.microsoft.com/kb/291323/ )Sample macro code to change the case of text in Excel
(http://support.microsoft.com/kb/213566/ )How to create application-level event handlers
(http://support.microsoft.com/kb/213646/ )How to Use the Left, Right, Mid, and Len Functions in Visual Basic
(http://support.microsoft.com/kb/213837/ )How to run subroutines and macros from Visual Basic in Excel 2000 or Excel 2002
(http://support.microsoft.com/kb/220595/ )How to automate Outlook by using Visual Basic
(http://support.microsoft.com/kb/285202/ )List of Outlook object model constants
(http://support.microsoft.com/kb/287531/ )List of resources for custom forms and programming with Outlook 2002
(http://support.microsoft.com/kb/290500/ )Description of the developer-related e-mail security features in Outlook 2002
(http://support.microsoft.com/kb/291926/ )How to use the WebBrowser control on a slide
(http://support.microsoft.com/kb/291876/ )How to control a Shockwave Flash Control on a slide in PowerPoint
(http://support.microsoft.com/kb/306258/ )How to create a combo box that contains more than 25 items in Word 2002
(http://support.microsoft.com/kb/306348/ )How to programmatically save each page or section of a document as a separate file
(http://support.microsoft.com/kb/306281/ )How to store and retrieve variables in documents
(http://support.microsoft.com/kb/306338/ )Sample macro that uses a loop to find text
(http://support.microsoft.com/kb/306248/ )Sample macro to list all files in a folder
(http://support.microsoft.com/kb/291474/ )How to update fields in a protected form in Word 2003 and in Word 2002
(http://support.microsoft.com/kb/306346/ )Sample macro to print all Word documents found in a folder
Other Web resourcesThe 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
Article ID: 305326 - Last Review: November 19, 2012 - Revision: 2.0
Contact us for more help
Connect with Answer Desk for expert help.