Microsoft Excel Macro Programming Using VBA

Planning Information

The duration of this course is 1 Day.
Classes are priced from $375.00. See individual sessions for details.


The Visual Basic for Applications programming language is a powerful addition to all Office, and particularly useful in Microsoft® Excel®.

Intended Audience

The Excel VBA class is intended for students who wish to enhance their knowledge of Excel and utilize the power of macros to automate tasks. 

At Completion

Upon completion of this course, students will have a basic understanding of VBA and the macros produced by it. They will also leave with a set of working macros that cover basic logic and functionality. 


Students should know how to create and save workbooks, create formulas, use basic functions. 


Courseware Microsoft Office Excel 2007: VBA Programming

Course Outline

Lesson 1 : The Visual Basic Editor

  • Visual Basic for Applications (VBA)
  • Object programming
  • The Object Browser

Lesson 2: Programming Basics

  • Data basics
  • Scope of variables
  • Scope of procedures

Lesson 3: Control Structures

  • Decision structures
  • Loop structures
  • Control structures

Lesson 4: Custom Dialog Boxes

  • User Forms
  • Events

Lesson 5: Debugging and Error Handling

  • Errors
  • Debugging
  • Error handling
  • Debugging and error handling

To request private training or future dates, call 610-321-3500 or
Register your interest now

Related Courses

Pin It on Pinterest

Share This