Stricklen Solutions Logo
View Store
Main Menu

Introduction to Excel VBA Programming

LEVEL: INTERMEDIATE

This hands-on course is an introduction to programming with Visual Basic for Applications (VBA) in Microsoft Excel. Students will learn how to work with loops, functions, control structures, object variables, arrays, and much more. By the end of the course participants will have the essential skills required to write their own procedures, create custom worksheet functions, and develop a simple Excel add-in using VBA. No programming experience is required.

This course is taught by Steve Stricklen, creator of over one-hundred Excel VBA applications and two top-selling Excel add-ins.

You Will Learn How To:

  • Write Your Own Procedures
  • Create Custom Worksheet Functions
  • Automate Excel Functionality
  • Build a Simple Excel Add-In
  • And Much More!

Other Benefits of Excel VBA Training:

  • Instructor Support After the Training
  • Discounts on Excel Add-ins

Choose the Best Training Solution For You or Your Organization

Open Enrollment

2-Day Live,
Instructor-Led

Online Excel VBA training via Zoom
View Schedule

Team Training

Online or On-Site,
Customizable

Live, instructor-led training for your group or staff
Contact Us

Excel VBA Introduction Course Information

The public course is two days, 9-4 CST. Please see the schedule for more details.

For private groups this course can be conducted in a 2 or 3 day format, and can be customized. The third day can be used to cover a specific project or example.

This is an Excel VBA Workshop. It's hands-on. The students will spend most of their time writing code, following along with a live instructor. Some PowerPoint slides and other documents may be used in the training but the student will spend very little time reading. Example files and other digital training material needed by the student will be emailed in advance or shared during the course.

Intermediate Excel skills recommended. No programming experience required

This course requires Microsoft Excel 2007 or later versions. The instructor will be using Excel 365 / Windows 11, which is recommended.

Our 220+ page Introduction to Excel VBA Programming booklet is optional. While we do use it as a guide for the training, it is not required by the student to follow along with the instructor.

The booklet, however, does serve as an excellent reference after the training and includes additional exercises, examples, and quick-reference sheets. And it can be branded with your company's logo and colors. Great for team training!

IMG_1933

Your Instructor

Meet Steve - an Excel VBA instructor with 20+ years experience in programming and development. His expertise and passion for teaching make him an excellent choice for anyone looking to enhance their skills. Learn foundational Excel VBA knowledge and automate tasks. Join Steve's class today.

Excel VBA Introduction Course Outline

  • What is VBA?
  • Why Learn to Program with VBA?
  • The Programmer's Edge
  1. Macro Recorder Overview
  2. Recording a Simple Macro
  3. Running a Recorded Macro
  4. Relative Recording
  5. Running a Relative Recording
  6. Viewing the Module
  7. Modifying a Recorded Macro
  8. The Personal Macro Workbook
  1. Creating a Recorded Application
  2. Examining the Data
  3. Recording a Summation Macro
  4. Recording an Averaging Macro
  5. Recording the Maximum Macro
  6. Recording the Minimum Macro
  7. Recording Divisional Macros
  8. Testing Macros
  9. Creating Objects to Run Macros
  10. Assigning a Macro to an Object
  1. User Defined Function Overview
  2. Creating a User Defined Function
  3. Using a User Defined Function
  4. Creating Another Function
  5. Passing Multiple Arguments
  6. Modifying a Function
  7. Creating a Function Library
  1. Overview of the VBA Editor
  2. Opening and Closing the Editor
  3. Working with the Project Explorer
  4. Working with the Properties Window
  5. Using the Work Area
  6. Working with a Code Module
  7. Running Procedures from the Editor
  8. Setting Break Points in ihe Editor
  9. Stepping Through a Procedure
  1. Overview of VBA
  2. Using the Immediate Window
  3. Working with Object Collections
  4. Setting Property Values
  5. Working with Worksheets
  6. Using the Object Browser
  7. Programming with the Object Browser
  1. Overview of Procedures
  2. Creating a Command Procedure
  3. Making Sense of IntelliSense
  4. Using ohe Edit Toolbar
  5. Commenting Statements
  6. Indenting Text
  7. Bookmarking in Procedures
  1. Overview of Variables
  2. Creating and Using Variables
  3. Implicit and Explicit Declarations
  4. The Scope of Variables
  5. Procedure Level Scoping
  6. Module Level Scoping
  7. Public Scoping Of Variables
  8. Passing Variables by Reference
  9. Passing Variables by Value
  10. Avoiding Variant Data Types
  11. Using Arrays
  1. Overview of the Excel Object Model
  2. Splitting the Screen
  3. Using Workbook Objects
  4. Using Worksheet Objects
  5. Using Range Objects
  6. Using Objects in a Procedure
  1. Understanding Programming Conventions
  2. Communicating with the User
  3. Prompting for User Input
  4. Using the Input Method
  5. Using IF to Make Decisions
  6. Testing For Multiple Conditions
  7. Looping a Fixed Number of Times
  8. Looping a Specified Number of Times
  9. Looping an Unknown Number Of Times
  1. Custom Forms Overview
  2. Creating a Custom Form
  3. Changing the Form Properties
  4. Adding Text Boxes to the Form
  5. Moving Controls
  6. Adding Label Controls to the Form
  7. Changing Text Box Control Properties
  8. Changing Label Control Properties
  9. Adding a Combo Box
  10. Adding Option Buttons
  11. Adding Command Buttons
  12. Running a Form
  1. Overview Forms Programming
  2. Initializing the Form
  3. Closing the Form
  4. Updating the List
  5. Creating Error Checking Procedures
  6. Running a Form from a Procedure
  7. The Personal Macro Workbook
  1. Overview of the Ribbon
  2. Creating a New Ribbon Tab
  3. Creating a Group
  4. Adding Ribbon Icons
  5. Customizing the Quick Access Toolbar (QAT)
  6. Assigning Macros to Icons
  1. Overview of Automatic Startup
  2. Programming Automatic Events
  3. Running Automatic Procedures
  4. Automatically Starting the Workbook
  5. Creating an Add-in Workbook
  • What's Next?
  • Where to Get Help
  • Writing Code
  • Think Like a Programmer

Excel VBA Introduction Training FAQs

This course is applicable to Excel 2007 and newer versions. Instructor will be using Excel 365/Win 10.

For Mac users, most of the material will be the same, but we highly recommend using a Windows PC during the training.

Yes, individuals can enroll in one of our open-enrollment courses, which are conducted online using Zoom. 

Or, for organizations, we can teach your group or staff in a private online session using an online service you choose. Private sessions can also be customized.

Our public courses are guaranteed to run. If, for some reason, the course does not occur, you will receive a full refund.

100% Satisfaction Guarantee!*

*Contact us for more details

Questions about the Excel VBA Training?

Let us know how we can help. We’ll get in touch within one business day.

"An excellent introduction to programming"
Ryan G.
Financial Analyst
SERVICES
VBA COURSES
COMPANY
CONNECT
Linkedin Facebook-f Twitter