International Institute for Learning, Inc.
Microsoft® Project Certifications
Microsoft® Excel Visual Basic for Applications (VBA)
Mastering Automation - Making Things Happen Fast!
Print Download PDF  
IIL Virtual Classroom
Course No.:
Duration:
Credits:
8857
Two 3-hour sessions
6 PDUs / 0.6 CEUs
 
Prerequisites:

A solid working knowledge of Excel, and a desire to get more deeply into the programming language built in to Excel - Visual Basic for Applications.

Course Level: Intermediate/ Advanced
 
 

About The Program
This practical course provides a solid background in the capabilities and usage of Visual Basic® for Applications (VBA) programming. It explores macro recording, editing, writing macros from scratch, making User Forms and creating user-defined functions.

The goal of this course is to provide access to the programming environment of Excel® and enable participants to make macros that are always available to make their usage of Excel easier.

Who Should Attend
This course is for anyone with a solid working knowledge of Excel.

What You Will Learn
You’ll learn how to:

  • Record macros
  • Edit macros
  • Debug macros
  • Create and use User Forms
  • Create user-defined functions
  • Explore Event-driven macros (macros which run when some event occurs, like printing or saving or using a right-mouse click)

Course Overview
Getting Started

  • Introductions
  • Course structure
  • Course goals and objectives

Macros and User Forms

  • Record, edit and maintain your macros
  • Learn what can and cannot be recorded
  • A quick look at syntax
  • A discussion of functions and User Forms

Course Outline

  • Record macros
  • Examine and learn about the VBE (Visual Basic Environment) - the place where macros are stored
  • Get information to/from a workbook
    - How to design a User Form
    - When to use it, when not
    - How to get information to/from a User Form
    - Learn the various controls on a User Form (button, checkbox, textbox, etc.)
    - Using Input boxes and getting messages to a user
  • Make repetitive tasks happen without errors and quickly: for example, updating a monthly report using new data
  • Create your own set of personal utilities which are available to you in every workbook
  • Create your own functions in addition to Excel’s wide set, like a weighted average function
  • Debugging
  • Prevent a workbook from being saved or printed unless all required fields are filled in

Summary

  • What did we learn, and how can we implement this in our work environments?
 
 
©2000-2010 International Institute for Learning, Inc.