Microsoft Excel 2002 (XP): VBA Programming

Show more Microsoft Training Courses

About this class

Students will learn to create and edit macros, and gain an understanding of VBA code.

Who will the lesson benefit?

This course is designed for students who are familiar with Excel as a user and wish to progress to programming.

What delegates will learn

Students will examine sample code, learn how to create macros from scratch, and add to previously created macros.

What prerequisites are required

Excel 2002 Advanced or equivalent knowledge.

Contents of this class

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

Microsoft Excel 2002 (XP): VBA Programming / MEX02-V2

(C) AquinasTraining.co.uk - Contact Us