Microsoft KB Archive/274705

= OFF2001: Programming Resources for Visual Basic for Applications =

Article ID: 274705

Article Last Modified on 7/18/2007

-

APPLIES TO


 * Microsoft Excel 2001 for Mac
 * Microsoft PowerPoint 2001 for Mac
 * Microsoft Word 2001 for Mac

-



This article was previously published under Q274705



For a Microsoft Office 98 Macintosh Edition version of this article, see 163435.

For a Microsoft Office 2000 version of this article, see 226118.



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
 * 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



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.
 * 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, select 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

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 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 type the code.

To access the Microsoft Knowledge Base on the World Wide Web, visit the following Microsoft Web site:

http://support.microsoft.com/?pr=kbinfo

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

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

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 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:

http://msdn2.microsoft.com/en-us/isv/Bb190538.aspx

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

http://www.microsoft.com/communities/default.mspx

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

Microsoft Office Developer Center:

http://msdn.microsoft.com/office/

Microsoft Visual Basic Web site:

http://msdn.microsoft.com/vbasic/

Microsoft Developer Network Web site:

http://msdn.microsoft.com

Visual Basic Online Developer (from Pinnacle Publishing Inc.):

http://www.pinnaclepublishing.com/

Summit Web site for Microsoft VBA:

http://www.microsoft.com/europe/vba/

Additional query words: xl2001 wd2001 vba2001 OFF2001 ppt2001 vba vbe vb mac OFF2001KB macro visual basic automation automatic code

Keywords: kbfaq kbinfo kbprogramming KB274705

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.