Microsoft® Excel Visual Basic for Applications (VBA)
Mastering Automation - Making Things Happen Fast!
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.
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
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.)
Summary
What did we learn, and how can we
implement this in our work environments?
•
Take advantage of the flexibility, customization, focus and control that onsite training offers and let us tailor a course or program to align with your
company’s mission, values and unique business needs. We can deliver any course to your team or organization in a private format - at your location, at
one of our training sites or in a virtual setting. Email us at onsite@iil.com for a free consultation today or visit www.iil.com/onsite for more information.
VIRTUAL CLASSROOM: Dynamic and fully interactive, a live, online version of this course is led by an instructor and conducted in real time.
#8857 / Two 3-hour sessions
CEU Credits: 0.6 / PDU Credits: 6
Price: USD 495
TRADITIONAL CLASSROOM: Engage with our instructors and a diverse group of peers in a Traditional Classroom version of this course.
Contact your local IIL company for details
ON-DEMAND LEARNING: Set your own pace
with a recorded online version of this course
and log on when and where you learn best.
#PA8857 / Two 3-hour sessions
CEU Credits: 0.6 / PDU Credits: 6
Price: USD 495
