Microsoft KB Archive/226118

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Article ID: 226118

Article Last Modified on 7/18/2007



APPLIES TO

  • Microsoft Excel 2000 Standard Edition
  • Microsoft Access 2000 Standard Edition
  • Microsoft Outlook 2000 Standard Edition
  • Microsoft PowerPoint 2000 Standard Edition
  • Microsoft Word 2000 Standard Edition



This article was previously published under Q226118

For a Microsoft Office XP version of this article, see 305326.
For a Microsoft Office 97 and Microsoft Office 98 Macintosh Edition version of this article, see 163435.


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:

  • 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

  • Use the 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.


NOTE: You MUST be in the Visual Basic Editor in order to get help on objects, methods, or properties in Visual Basic for Applications. To open the Visual Basic Editor in any application that supports it, press ALT+F11.

  • 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.

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. From the View menu, click Object Browser (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. Use the Class list to 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. 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 2000
   ---------------------

   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://www.microsoft.com/mspress/books/2321.asp
<!-- 
   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 2000
   ---------------------

   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.asp

   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.asp

   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.asp

   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.asp

   Microsoft Excel 2000
   --------------------

   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.asp

   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.asp

   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.asp


   Microsoft Outlook 2000
   ----------------------

   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.asp

   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.asp

   Microsoft PowerPoint 2000
   -------------------------

   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.asp


   Microsoft Word 2000
   -------------------

   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.asp


   Microsoft Visual Basic 2000
   ---------------------------

   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.asp
<!--
   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 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


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

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


253235 FILE: OFFAUTMN.EXE Discusses Office 97 and 2000 Automation and Provides Sample Code


210143 ACC2000: Tips for Debugging Visual Basic for Applications Code


212673 WD2000: Troubleshooting Variables and Data Types


Microsoft Access

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


209811 ACC2000: Tips on How to Troubleshoot Microsoft Access Macros


210111 ACC2000: Using Microsoft Access as an Automation Server


210588 ACC2000: How to Parse Comma-Separated Text into Multiple Fields


Microsoft Excel

213578 XL2000: How to Assign a Macro to an ActiveX Worksheet Control


211563 XL2000: How to Create an Add-in File


213550 XL2000: Sample Macros for Customizing Menus and Submenus


213763 XL2000: How to Programmatically Create a Collection


Microsoft Outlook

209963 ACC2000: How to Use Automation to Add Appointments to Microsoft Outlook


209955 ACC2000: How to Use Automation to Create a New Contact Item in Microsoft Outlook


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


Microsoft PowerPoint

222771 PPT2000: Introduction to Macro Programming in PowerPoint 2000


222758 PPT2000: How to Use the Presentations.Open Method


222790 PPT2000: Sample Code to Display the Selection Type


222768 PPT2000: Sample Code to Assign a Random Animation to All Objects


Microsoft Word

212682 WD2000: VBA Macro Examples to Insert Text into a Document


212710 WD2000: Retrieving Settings from Word Dialog Boxes Using OLE


201950 WD2000: 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 that are available to help you interact with other users of Visual Basic for Applications:

For more information about Microsoft Internet newsgroups, please visit the following Microsoft World Wide Web site:

Other Web Resources

The following Web sites are also of interest to Visual Basic for Applications programmers:


Additional query words: xl2000 wd2000 acc2000 vba2000 OFF2000 ppt2000 vba vbe vb

Keywords: kbhowto kbfaq kbinfo kbprogramming KB226118