Excel 2000 Visual Basic for Applications

Introduction to Visual Basic for Applications

• Running a macro
• Recording a macro
• Examining module design

Assigning macros

• Specifying the location of recorded macros
• Assigning macros to menus, buttons, and toolbars

Creating decision-making code

• The If ... Then decision structure
• The If ... Then ... Else decision structure
• The Select Case decision structure

Using loop structures

• Using a For... Next statement
• Using a Do... Loop statement
• Using a For Each... Next statement

User-defined functions and variables

• Creating user-defined functions
• Creating variables

Interactive macros

• Creating a custom message box
• Creating a custom input box
• Extracting data from Excel

Macro management

• Personal Macro Workbook
• Assigning Subprocedures to run automatically

Debugging and testing code

• Overview of debugging

Programming basics

• Coding
• Variables
• Procedures
• Error handling
• Naming conventions