Programming resources for Visual Basic for Applications

Article ID: 163435 - View products that this article applies to.
This article was previously published under Q163435
For a Microsoft Office XP version of this article, see 305326
(http://support.microsoft.com/kb/305326/ )
.

For a Microsoft Office 2000 version of this article, see 226118
(http://support.microsoft.com/kb/226118/ )
.
Expand all | Collapse all

On This Page

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.

Note If you selected Typical when you installed Office 97, you need to run Setup again to install the Help files associated with Visual Basic for Applications for the programs you will be working with.

For more information about how to install the VBA Help files, click the following article number to view the article in the Microsoft Knowledge Base:
176476
(http://support.microsoft.com/kb/176476/ )
Office Assistant not answering Visual Basic questions

Microsoft Press and Third-Party Reference and Learning Materials

The third-party contact information that is 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 97 Visual Basic Step by Step
Author: David Boctor
Publisher: Microsoft Press
Date: 1997
ISBN: 1-57231-389-7
Pages: 334
Includes: One CD

Title: Microsoft Office 97, Developer Edition, Resource Library
Author: Christine Solomon, Eric Wells, Timothy M. O'Brien, Steven J. Pogge, and Geoffrey E. White
Publisher: Microsoft Press
Date: 1997
ISBN: 1-57231-606-3
Pages: 1888

Title: Microsoft Office 97 Developer's Handbook
Authors: Christine Solomon
Publisher: Microsoft Press
Date: 1997
ISBN: 1-57231-440-0
Pages: 608
Includes: One CD
Web Site: http://www.microsoft.com/mspress/books/1211.aspx
(http://www.microsoft.com/mspress/books/1211.aspx)


Title: Microsoft Office 97/Visual Basic Programmer's Guide
Publisher: Microsoft Press
Date: 1997
ISBN: 1-57231-340-4
Pages: 560

Title: VBA For Dummies, 2nd Edition
Author: Steve Cummings
Date: August 1999
ISBN: 0-7645-0567-X

Title: VBA Developer's Handbook
Author: Ken Getz and Mike Gilbert
Publisher: SYBEX, Inc.
ISBN: 0-7821-1951-4

Title: Teach Yourself Visual Basic for Applications 5 in 21 Days, Third Edition
Author: Matthew Harris
Publisher: SAMS
ISBN: 0-6723-1016-3

Title: Visual Basic for Applications Unleashed
Author: Paul McFedries
Publisher: SAMS
Date: 1997
ISBN: 0-6723-1046-5

Title: Special Edition Using Visual Basic for
Applications 5
Author: Paul Sanna
Publisher: QUE
Date: 1997
ISBN: 0-7897-0959-7

Microsoft Access

Title: Microsoft Access 97 Developer's Handbook
Publisher: Microsoft Press
Date: 1997
ISBN: 1-57231-358-7
Pages: 624
Disk: One CD

Title: Microsoft Access 97/Visual Basic Step by Step
Author: Evan Callahan
Publisher: Microsoft Press
Date: 1997
ISBN: 1-57231-319-6
Pages: 416
Includes: One CD

Title: Microsoft Jet Database Engine Programmer's Guide, Second Edition
Publisher: Microsoft Press
Date: December 1995
ISBN: 1-57231-342-0
Pages: 792
Includes: One CD

Title: Access 97 Expert Solutions
Author: Stan Leszynksi
Publisher: QUE
Date: 1997
ISBN: 0-7897-0367-X
Pages: 1200


Title: Access 97 Power Programming
Author: F. Scott Barker
Publisher: QUE
Date: 1997
ISBN: 0-7897-0915-5

Title: Access 97 Macro and VBA Handbook
Author: Susann Novalis
Publisher: SYBEX, Inc.
Date: February 1997
ISBN: 0-7821-1977-8
Web Site: http://www.sybex.com
(http://www.sybex.com)


Title: Access 97 Developer's Handbook
Author: Paul Litwin, Ken Getz and Mike Gilbert
Publisher: SYBEX, Inc.
Date: 1997
ISBN: 0-7821-1941-7
Web Site: http://www.sybex.com
(http://www.sybex.com)


Title: Mastering Access 97
Author: Alan Simpson and Elizabeth Olson
Publisher: SYBEX, Inc.
ISBN: 0-7821-1924-7
Web Site: http://www.sybex.com
(http://www.sybex.com)


Title: Alison Balter's Mastering Access 97 Development, Premier Second Edition
Author: Alison Balter
Publisher: SAMS
Date: 1997
ISBN: 0-672-30999-8

Title: Access 97 Programming For Windows For Dummies
Author: Rob Krumm
Publisher: IDG Books Worldwide, Inc.
Date: March 3, 1997
ISBN: 1-56884-696-7
Web Site: http://www.dummies.com
(http://www.dummies.com)

Microsoft Excel

Title: Excel 97 Programming For Windows For Dummies
Author: John Walkenbach
Publisher: IDG Books Worldwide, Inc.
Date: June 19, 1997
ISBN: 0-7645-0132-1
Web Site: http://www.dummies.com
(http://www.dummies.com)


Title: Special Edition Using Microsoft Excel 97
Author: Ron Person
Publisher: QUE
Includes: An introduction to Visual Basic for Applications

Microsoft PowerPoint

Title: Running Microsoft PowerPoint 97
Author: Stephen Sagman
Publisher: Microsoft Press
Date: 1997
ISBN: 1-57231-324-2
Pages: 508
Includes: One CD; one chapter on Visual Basic for Applications.

Title: Special Edition Using Microsoft PowerPoint 97
Author: Nancy Stevenson
Publisher: QUE
Date: 1997

Microsoft Word

Title: Microsoft Word 97/Visual Basic Step by Step
Author: Michael Halvorson and Chris Kinata
Publisher: Microsoft Press
Date: April 1997
ISBN: 1-57231-388-9
Pages: 320
Includes: One CD

Title: Special Edition Using Microsoft Word 97
Author: Ron Person
Publisher: QUE

Title: Word 97 Macro and VBA Handbook
Author: Guy Hart-Davis
Publisher: SYBEX, Inc.
Date: April 1997
ISBN: 0-7821-1962-X
Includes: One CD

Microsoft Visual Basic

Title: Microsoft Visual Basic, Deluxe Learning Edition
Publisher: Microsoft Press
Date: March 1997
ISBN: 1-57231-551-2
Pages: 1278

Title: Microsoft Visual Basic 5 Step by Step
Author: Michael Halvorson
Publisher: Microsoft Press
Date: March 1997
ISBN: 1-57231-435-4
Pages: 416
Includes: One CD

Title: Microsoft Visual Basic 5.0 Developer's Workshop, Fourth Edition
Author: John Clark Craig, Webb
Publisher: Microsoft Press
Date: May 1997
ISBN: 1-57231-436-2
Pages: 752
Includes: One CD

Title: Advanced Microsoft Visual Basic 5
Author: The Mandelbrot Set, Ltd.
Publisher: Microsoft Press
Date: 1997
ISBN: 1-57231-414-1
Pages: 832

Title: Microsoft Visual Basic 5.0 Programmer's Guide
Publisher: Microsoft Press
Date: July 1997
ISBN: 1-57231-604-7
Pages: 912

Title: Visual Basic 5 Developer's Guide
Author: Anthony T. Mann
Publisher: SAMS
ISBN: 0-6723-1048-1

Title: Visual Basic 5 Interactive Course
Author: John Harrington, Mark Spenik, Heidi Brumbaugh, Cliff Diamond
Publisher: Waite Group Press
Date: March 1997
ISBN: 1-5716-9077-8

Title: Special Edition Using Visual Basic 5
Author: Mike McKelvy, Ronald Martinsen, Jeff Webb, Bob Reselman
Publisher: QUE
Date: March 1997
ISBN: 0-7897-0922-8

Title: Visual Basic Algorithms
Author: Rod Stephens
Publisher: Wiley Computer Publishing
Web Site: http://www.wiley.com/compbooks/stephens/vba.htm
(http://www.wiley.com/compbooks/stephens/vba.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 Microsoft Knowledge Base on the World Wide Web, visit the following Microsoft Web site:
http://support.microsoft.com/search
(http://support.microsoft.com/search)
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
(http://support.microsoft.com/kb/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.

Microsoft Office

159748
(http://support.microsoft.com/kb/159748/ )
How to protect VBA Code from unauthorized access
161923
(http://support.microsoft.com/kb/161923/ )
Troubleshooting variables and data types
161014
(http://support.microsoft.com/kb/161014/ )
How to animate the Office Assistant
161246
(http://support.microsoft.com/kb/161246/ )
Sample code to get input from an Office Assistant balloon
142999
(http://support.microsoft.com/kb/142999/ )
Tips for debugging Visual Basic for Applications code
253235
(http://support.microsoft.com/kb/253235/ )
OFFAUTMN.exe discusses Office 97 and 2000 Automation and provides sample code

Microsoft Access

147816
(http://support.microsoft.com/kb/147816/ )
Using Microsoft Access as an automation server
95608
(http://support.microsoft.com/kb/95608/ )
How to parse comma-separated text into multiple fields
89610
(http://support.microsoft.com/kb/89610/ )
Tips on how to troubleshoot Microsoft Access macros
131583
(http://support.microsoft.com/kb/131583/ )
Sending the current record to Word 97 with automation

Microsoft Excel

146197
(http://support.microsoft.com/kb/146197/ )
How to find technical information about Microsoft Excel
157416
(http://support.microsoft.com/kb/157416/ )
How to assign a macro to an ActiveX worksheet control
156942
(http://support.microsoft.com/kb/156942/ )
How to create an add-in file in Microsoft Excel 97
159619
(http://support.microsoft.com/kb/159619/ )
Sample macros for customizing menus and submenus
161215
(http://support.microsoft.com/kb/161215/ )
How to programmatically create a collection
141691
(http://support.microsoft.com/kb/141691/ )
Visual Basic example using If and Case staments
146055
(http://support.microsoft.com/kb/146055/ )
Using Visual Basic to create a chart using a dynamic range
141762
(http://support.microsoft.com/kb/141762/ )
How to use looping structures in Visual Basic for Applications
143345
(http://support.microsoft.com/kb/143345/ )
Visual Basic macro to determine which button was selected

Microsoft Outlook

170783
(http://support.microsoft.com/kb/170783/ )
Questions about customizing or programming Outlook
166368
(http://support.microsoft.com/kb/166368/ )
Resources for custom forms and programming
160502
(http://support.microsoft.com/kb/160502/ )
Using automation to add appointments to Microsoft Outlook
161012
(http://support.microsoft.com/kb/161012/ )
How to create a new Contact item in Outlook with automation
161088
(http://support.microsoft.com/kb/161088/ )
Using automation to send a Microsoft Outlook message

Microsoft PowerPoint

162102
(http://support.microsoft.com/kb/162102/ )
Introduction to macro programming in PowerPoint 97
162555
(http://support.microsoft.com/kb/162555/ )
How to use the Presentations.Open method
161390
(http://support.microsoft.com/kb/161390/ )
Sample code to display the selection type
162180
(http://support.microsoft.com/kb/162180/ )
Sample code to assign a random animation to all objects

Microsoft Word

161407
(http://support.microsoft.com/kb/161407/ )
VB macro examples to insert text into a document
159547
(http://support.microsoft.com/kb/159547/ )
Retrieving settings from Word dialog boxes using OLE
162490
(http://support.microsoft.com/kb/162490/ )
How to access sample macros for Word 97
146899
(http://support.microsoft.com/kb/146899/ )
Sample macros to scroll to top or bottom of document window

Microsoft TechNet

There is a wealth of valuable information available on the TechNet compact disc. For a good example of the type of information you can find on TechNet, click the hyperlink below to visit the TechNet web site:
http://technet.microsoft.com/default.aspx
(http://technet.microsoft.com/default.aspx)
TechNet often includes information about Visual Basic for Applications.

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.outlook97.program_forms
microsoft.public.vb.ole.automation
microsoft.public.vb.database.dao
microsoft.public.vb.database.odbc
microsoft.public.vb.database.rdo
microsoft.public.word.vba.addins
microsoft.public.word.vba.beginners
microsoft.public.word.vba.customization
microsoft.public.word.vba.general
microsoft.public.word.vba.userforms
 

Other Web Resources

The following Web sites are also of interest to Visual Basic for Applications programmers:
Office Development Web site at the following Web address:
http://msdn.microsoft.com/office/
(http://msdn.microsoft.com/office/)
Developer Publications at the following Web address:
http://www.microsoft.com/learning/books/
(http://www.microsoft.com/learning/books/)
Microsoft Visual Basic Web site at the following Web address:
http://www.msdn.microsoft.com/vbasic/
(http://msdn.microsoft.com/vbasic/)
Microsoft Developer Network online at the following Web address:
http://msdn2.microsoft.com/en-us/default.aspx
(http://msdn2.microsoft.com/en-us/default.aspx)
Summit Web site for Microsoft VBA at the following Web address:
http://msdn2.microsoft.com/en-us/isv/bb190538.aspx
(http://msdn2.microsoft.com/en-us/isv/bb190538.aspx)
Back to the top | Give Feedback

Properties

Article ID: 163435 - Last Review: November 15, 2012 - Revision: 16.0
Applies to
  • Microsoft Office 98 for Macintosh
  • Microsoft Office 97 Standard Edition
  • Microsoft Excel 98 for Macintosh
  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 95 Standard Edition
  • Microsoft PowerPoint 98 for Macintosh
  • Microsoft PowerPoint 97 Standard Edition
  • Microsoft Access 97 Standard Edition
  • Microsoft Outlook 97 Standard Edition
  • Microsoft Word 98 for Macintosh
  • Microsoft Word 97 Standard Edition
Keywords: 
kb3rdparty kbinfo kbprogramming KB163435
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
Back to the top | Give Feedback

Give Feedback

 
Back to the topBack to the top