TRADITIONAL CLASSROOM: Engage with our
instructors and a diverse group of peers in a
Traditional Classroom version of this course .
VIRTUAL CLASSROOM: Dynamic and fully
interactive, a live, online version of this course is
led by an instructor and conducted in real time .
ON-DEMAND LEARNING: Set your own pace
with a recorded online version of this course
and log on when and where you learn best .
Customized Learning: We will tailor any course based on your company’s needs .
For a free consultation or quote please email Learning@iil.com or visit www.iil.com/onsite.
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
The goal of this course is to provide access to
the programming environment of Excel and
enable you to create macros that are always
available, facilitating your use of Excel.
A solid working knowledge of Excel, and a
desire to get more deeply into the
programming language built into Excel -
Visual Basic for Applications .
Who Should Attend
• Anyone with a solid working knowledge of
• Exploring the programming side of Excel
• Creating macros to make your use of Excel
more efficient and effective
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 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
• 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 and when not to use it
- How to get information to/from a User
- 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 quickly and
without errors: for example, updating a
monthly report using new data
• Create your own set of personal utilities that
are available to you in every workbook
• Create your own functions in addition to
Excel’s wide set, such as a weighted average
• Prevent a workbook from being saved or
printed unless all required fields are filled in
• What did we learn, and how can we
implement this in our work environments?
#8857 / Two 3-hour sessions
CEU Credits: 0 . 6 / PDU Credits: 6
Price: USD 450
IIL/University Price: USD 695
Contact your local IIL company for details
Microsoft®, Visual Basic®, and Excel® are registered trademarks of Microsoft Corporation in the United States and other countries.