OFF2000: Programming Resources for Visual Basic for Applications

ID: q226118

The information in this article applies to:

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:


MORE INFORMATION

Online Help

The Help files included with Microsoft Office are useful for learning the syntax for specific Visual Basic for Applications methods or properties. To display the context-sensitive Help file for a particular Visual Basic command, type the command on a module sheet, and then press F1. This provides the syntax, a description, and an example of how the command is used.

Microsoft Press and Third-Party Reference and Learning Materials

The third-party contact information included in this article is provided to help you find the technical support you need. This contact information is subject to change without notice. Microsoft in no way guarantees 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:     Programming Microsoft Access 2000
   Author:    Rick Dobson
   Publisher: Microsoft Press
   Date:      May 7, 1999
   ISBN:      0-7356-0500-9
   Pages:     624
   Disk:      1 CD
   Web Site:  http://mspress.microsoft.com/books/2351.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:      March 10, 1999
   ISBN:      0-7356-0509-2
   Includes:  1 
   Web Site:  http://mspress.microsoft.com/books/2364.htm

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 it would take to manually enter the code.

To access the Knowledge Base on the Internet, follow these steps:

  1. Connect to the Knowledge Base using the following Web address:

    http://support.microsoft.com/support/search/c.asp


  2. In the My search is about list, click the product you are interested in. To search all products, click All Products.


  3. In the I want to search by section, select Asking a question using Natural Language Search.


  4. In the My Question Is section, type your question, and then click Go.

    -or-

    If you already have an ARTICLE-ID (Q number), select the Specific Article ID number option in the I want to search by section, and type the Q number in the My Question is box. Click Go.

    For help on searching, click the How to Search or the Search Examples link.


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

Q222791 PPT2000: Sample Code to Get Input from an Office Assistant

Microsoft Access

Q210271 ACC2000: Sending the Current Record to Word 2000 with Automation


Microsoft Excel

Q213578 XL2000: How to Assign a Macro to an ActiveX Worksheet Control
Q211563 XL2000: How to Create an Add-in File
Q213550 XL2000: Sample Macros to Control Menus and Submenus

Microsoft Outlook


Q209948 ACC2000: How to Use Automation to Send a Microsoft Outlook Message

Microsoft PowerPoint


Q222771 PPT2000: Introduction to Macro Programming in PowerPoint 2000
Q222758 PPT2000: How to Use the Presentations.Open Method
Q222790 PPT2000: Sample Code to Display the Selection Type
Q222768 PPT2000: Sample Code to Assign a Random Animation to All Objects

Microsoft Word


Q201950 WD2000: Sample Code to Scroll to Top or Bottom of Window

Internet Newsgroups

The following peer-to-peer newsgroups are available to help you interact with other users of Visual Basic for Applications:
microsoft.public.access.devtoolkits
microsoft.public.access.formscoding
microsoft.public.access.macros
microsoft.public.access.queries
microsoft.public.excel.programming
microsoft.public.excel.sdk
microsoft.public.officedev
microsoft.public.outlook.program_vba
microsoft.public.vb.database.dao
microsoft.public.vb.database.odbc
microsoft.public.vb.database.rdo
microsoft.public.vb.general.discussion
microsoft.public.vb.ole.automation
microsoft.public.word.word97vba
microsoft.public.word.wordbasic
For more information about Microsoft Internet newsgroups, please see the following Microsoft World Wide Web site:
http://support.microsoft.com/support/news/default.asp

Other Web Resources

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

Microsoft Visual Basic Web site

Microsoft Developer Network Web site

Visual Basic Online Developer (from Pinnacle Publishing Inc.)

Summit Web site for Microsoft VBA

Additional query words: xl2000 wd2000 acc2000 vba2000 OFF2000 ppt2000 


Keywords          : kbprg 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbinfo

Last Reviewed: July 16, 1999