How to use Visual Basic for Applications in Excel (304494)


The information in this article applies to:

  • Microsoft Excel 2000
  • Microsoft Excel 2002
  • Microsoft Excel 97 for Windows
This article was previously published under Q304494
For a Microsoft Office Excel 2003 version of this article, see 842189.

SUMMARY

You can create macros with Microsoft Visual Basic for Applications (VBA) to automate common actions in Microsoft Excel. This article points to resources that can help you learn more about using VBA for this purpose.

MORE INFORMATION

For additional information about Visual Basic for Applications, click the following article numbers to view the articles in the Microsoft Knowledge Base:

163435 Programming resources for Visual Basic for Applications

141762 How to use Looping Structures in Visual Basic for Applications

149689 Visual Basic Macro examples for working with arrays

212536 How to run sample code from Knowledge Base articles

146864 Error Trapping with Visual Basic for Applications

118468 Definition of DoEvents in Visual Basic for Applications

226118 Programming resources for Visual Basic for Applications

184256 How to display "Now Processing" while a macro runs

165517 Overview of Visual Basic Editor debugging tools

164058 Passing procedure arguments in Visual Basic for Applications

Modification Type:MinorLast Reviewed:1/7/2006
Keywords:KbVBA kbinfo kbAutomation kbmacro kbhowto KB304494
©2004 Microsoft Corporation. All rights reserved.