EXCEL MACRO VBA PROGRAMMING
Level: Expert | Delivery Channel: In-Person Classroom or Virtually Online | CPE Credits: 24 Credits | Duration: 3 Days
This comprehensive three-day introduction course provides an exploration of Visual Basic for Applications (VBA), the integrated programming language used to automate and extend the capabilities of Microsoft Excel. Starting with the fundamentals of the VBA environment and terminology, the curriculum guides students through essential concepts such as variables, data types, and decision structures like loops and IF statements. Participants will learn to manipulate workbooks, worksheets, and ranges programmatically, as well as how to develop custom UserForms and create User Defined Functions (UDFs) to streamline complex workflows. Advanced topics include file management techniques, error handling, and linking Excel to external databases, empowering users to build robust, customized applications that transform manual tasks into efficient, automated operations.
WHO IS THIS CLASS FOR
Individuals with a strong Excel foundation skill set that want to level up with automating Excel tasks and extending the capabilities of Excel.
Automation-focused professionals who are tired of performing the same manual Excel tasks every day and want to build robust, one-click solutions to handle complex workflows.
WHAT YOU'LL LEARN
- Why use VBA if I can record macros in Excel?
- Recording a Simple macro
- Reviewing the code
- Familiarisation with the VBA environment
- Running Code from the VB Editor window
- Getting help on code
- Stepping through a procedure
- Using a Break point
- Communicating with the User
- Modules and procedures
- Components of your code
- Objects, Collections, Properties and methods
- Using the Excel Object model
- Working with variables and constants
- Using Data types
- Working with operators and expressions
- Implicit and Explicit Declarations
- Variable Scope – Procedural, Modular or Public
- Passing variables by Value
- Passing variables by Reference
- Using Arrays
- Workbook objects and methods
- Creating a new workbook
- Adding and Renaming Sheets
- Saving and Closing a Workbook
- Mathematical functions
- Date and time functions
- String functions
- Using Excel functions in VBA code
- Creating User Defined functions
- Using user-defined functions in a worksheet
- Declaring Multiple arguments in a function
- Creating a Function Library
- Do Until and Do While loops
- Looping at least once
- For Next Loop
- For Each Loops with collections
- Using IF to make decisions
- Testing for multiple conditions
- Establishing Flow control
- Branching
- Call other procedures
- Adding Names
- Deleting Names
- Creating Hidden Names
- Checking for the Existence of a Name
- Working with the Ranges and Selections
- Using the Cells Property to Select a Range
- Using the Offset Property to Refer to a Range
- Using the Columns and Rows Properties
- Using the Union Method to Join Multiple Ranges
- Using the IsEmpty Function
- Using the CurrentRegion Property
- Using the Areas Collection
- Open and Save files
- Copy, move and delete files
- Changing folders
- Using Excel Open and SaveAs dialog boxes in code
- Creating a user form
- Labels, text boxes, combo boxes and list boxes
- Setting properties for the form and controls
- Assigning data to combo boxes and list boxes
- Option buttons, Groups, checkboxes and buttons
- Creating the event code for controls
- Initialising the form
- Closing the form
- Using RefEdit to allow user interaction
- Linking Excel to an Access database
- Adding a Record to the Database from Excel
- Retrieving Records from the Database
- Updating an Existing Record
WHAT YOU WILL GET
- Class Binder with Step by Step Exercises and Challenge Exercises
- Microsoft Excel Exercise Files with 1 year access to the files
WHAT TO BRING TO CLASS
- We provide everything you need for our in-person classes. You just need to show up.
- Come dressed for comfort. Jeans, Shorts, Yoga pants are all welcome!
- Come ready to learn! Our classes are an intensive learning experience.
CLASS SCHEDULE
| Date | Location | Price | Registration |
|---|---|---|---|
| May 13, 2026 - May 15, 2026 9:15 AM to 5:00 PM |
Dallas Fort Worth (Hurst, TX) | $1,875.00 | Class is Full | Waiting List |
| August 19, 2026 - August 21, 2026 9:15 AM to 5:00 PM |
Dallas Fort Worth (Hurst, TX) | $1,875.00 | Register |
| December 9, 2026 - December 11, 2026 9:15 AM to 5:00 PM |
Dallas Fort Worth (Hurst, TX) | $1,875.00 | Register |
Do I need to have programming experience to take this class?
No prior programming experience is required. This course is designed to take you from the ground up, starting with the very basics of the VBA environment and terminology before moving into more complex automation logic.
What is the difference between recording a macro and writing VBA code?
Recording a macro is a great way to automate simple, repetitive tasks, but it is limited to exactly what you do on screen. Writing VBA code allows you to add "intelligence" to your spreadsheets—such as creating loops, making decisions with IF statements, and building custom user interfaces—that a recorder simply cannot do.
Will I learn how to create custom pop-up windows?
Yes. One of the key modules in this class covers Custom Forms and Dialog Boxes. You will learn how to design professional-looking user forms with text boxes, combo boxes, and buttons to create a custom interface for your use
Can I create my own Excel functions in this course?
Absolutely. You will learn how to write User Defined Functions (UDFs). These allow you to create custom formulas that perform specific calculations tailored to your business needs, which you can then use in your worksheets just like SUM or VLOOKUP.
Does the class cover how to connect Excel to other databases?
Yes. In the Managing Information with VBA module, we specifically cover how to link Excel to an Access database. You will learn how to add, retrieve, and update database records directly from your Excel interface.
Does this class qualify for CPE credits?
Yes! This class is accredited through the Texas State Board of Public Accountancy and earns 24 CPE (Continuing Professional Education) credits. You will receive a certificate of completion at the end of class.
Is there a live online option?
Yes. We offer this class in both in-person Dallas Fort Worth, Houston, Austin, Oklahoma City and live online formats. The online class is always led by a live instructor — not a pre-recorded video.
What do I need to bring to the in-person class?
Nothing! We provide a full-size training computer, class materials, and snacks and drinks throughout the day. Just bring yourself.
What materials do I take home after class?
You'll leave with the Excel practice file used during class and a student handbook so you can continue practicing on your own schedule.
How big are the public classes?
In-person public classes are small — up to 6 students — so you get plenty of individual attention from the instructor.
Can my whole team take this class together?
Absolutely. We offer private group training tailored to your team's schedule, location, and skill level.
Is the training hands-on or lecture-based?
Yes. Our classes are highly interactive with guided labs and exercises so participants practice every concept rather than just watching demonstrations.
I have more questions?
Our AI Chatbot has a wealth of knowledge and can answer most standards questions. Feel free to use our AI Chatbot in bottom right of the screen, feel free to use our Contact Form, and feel free to call us at 817-841-9560.
Got More Questions?
We are here to help! Call us at 817-841-9560 or use our Contact Form to get in touch with us.
