Introduction to Microsoft Office Excel Macros
and VBA

1 Day
Version 2007 and 2010

This instructor-led course, through lecture and hands-on exploration, will introduce students to the Microsoft Office macro programming environment and show students how to use Visual Basic for Applications to create more complex macros. Microsoft Excel is used as the platform for this course, although the concepts apply across the entire Microsoft Office suite.  In order to successfully complete this course, we strongly recommended that students have a strong familiarity with Microsoft Excel prior to taking this course.

Macros Management

Recording and Editing Macros

Using a Personal Macro Workbook

Running Macros Using the Quick Access
Toolbar

Understanding Macro Security Setting Considerations and Options

Introduction to Visual Basic for Applications

Understanding the Visual Basic Editor
Interface

Examining Module Design

Reviewing Excel Objects, Properties,
and Methods

Editing VBA Code Using the Visual
Basic Editor

Running a Macro From Within Another
Macro

Learning How to Debug a Macro

 

Using Loop Structures in VBA Code

Using a For...Next Statement

Using a Do...Loop Statement

Declaring and Using Variables in VBA

Understanding “With…End With” Syntax

Interactive Macros

Creating a Custom Message Box

Creating a Custom Input Box

Working With VBA Decision Making Code

The Select Case Decision Structure

The If...Then Decision Structure

Related Courses

Excel - Introduction Agenda

Excel - Intermediate Agenda

Excel - Advanced Agenda

Excel - Macro Recording and Programming


Not Sure What Level to Take?

Before taking the Intermediate or Advanced level class for this application, we ask that you take our free assessment to determine whether you are comfortable with the topics covered in the Introductory level class. Or, feel free to contact our office at (202) 747-5000 to speak with a representative to discuss the prerequisites.

Find us
Find us on Facebook  Find us on Twitter

Register online

Are you interested in a class for one or a few students? Consider taking a public class. View our public training schedule for dates.

Or, are you interested in scheduling a private group class at your office or at Softek? Learn more about our private group training.

Top of Page
Softek Services, Inc.