Welcome to “Excel VBA Programming – The Complete Guide”, your one-stop resource for mastering automation in Excel using Visual Basic for Applications (VBA). This is one of the most comprehensive VBA courses available—designed to take you from beginner to advanced, with over 18 hours of in-depth content.
VBA is a powerful programming language integrated into Microsoft Office applications like Excel, Access, and Outlook. It enables you to automate repetitive tasks through macros and create custom solutions within the familiar Excel environment. If it can be done in Excel, it can be automated with VBA!
What You'll Learn:
Starting from the basics and progressing to advanced techniques, the course covers:
Understanding the Excel Object Model
Navigating the Visual Basic Editor
Working with Objects, Methods, Variables, and Data Types
Writing Custom Procedures
Managing Workbooks, Worksheets, and Ranges
Performing Range Actions and Applying Conditional Logic
Using Loops and Iteration
Displaying Alerts and Modifying Excel Settings
Creating Custom Functions and Using Arrays
Debugging, Handling Events, and Building User Forms
No prior programming experience is required! This course is perfect for beginners and professionals alike. Since VBA is already included in modern versions of Excel, there’s no need for additional software.
Why Learn VBA?
Excel is the most widely used spreadsheet application in the world—installed on over 750 million computers. Learning VBA empowers you to eliminate manual, repetitive tasks and significantly boost your productivity—both personally and professionally.
Thanks for choosing this course. Let’s unlock the full potential of Excel together!
Who should take this Course?
The Excel VBA Programming Online Course is ideal for data analysts, financial professionals, business users, and anyone who wants to automate tasks, build custom functions, and enhance productivity within Microsoft Excel using Visual Basic for Applications (VBA). It’s also suitable for students and professionals working with large datasets or repetitive workflows. Basic knowledge of Excel is recommended, but no prior programming experience is required.
Course Curriculum
Getting Started
Introduction
Enable the Developer Tab
Excel File Types
Macro Security
The Macro Recorder
Absolute vs. Relative References I
Absolute vs. Relative References II
The Visual Basic Editor
The Fundamentals of the Excel Object Model
Object-Oriented Programming in Real Life
Collection Objects in Real Life
Objects as Properties
The Excel Object Model
Access Object from Collection by Name
Default Properties
The Name Property on Workbook and Worksheet Objects
The Visual Basic Editor
Visual Basic Editor Options
Create and Delete a Procedure
The Immediate Window and Debug.Print Method
The MsgBox Method
Comments
Objects and Methods
Methods without Arguments
Methods with Arguments
Methods with Multiple Arguments
The Object Browser
Ways to Invoke A Procedure
The TypeName Method
Variables and Data Types
Syntax Tips
Variable Declarations and Assignments
Multiple Variable Declarations
The Option Explicit Setting
The Byte, Integer and Long Data Types
Mathematical Operations
The Single and Double Data Types
The String Data Type
The Boolean Data Type
The Date Data Type
The Variant Data Type
The Object Data Type
Default Values for Declared Variables
Procedures
Variable Scope
Call A Procedure from Another one
Procedures with Arguments
Procedure Scope (Public vs. Private)
The Exit Sub Keywords
Constants
Predefined Constants
Object Deep Dive
The Application Object
The Application.DisplayAlerts Property
The Workbooks.Count and Worksheets.Count Properties
The Workbooks.Open Method and Workbook.Path Property
The Workbooks.Close Method
The Workbooks.Add Method
The Workbook.SaveAs and Workbook.Save Methods
The Workbook.Activate Method
The Workbook.Close Method
The Worksheets.Add Method
The Worksheet.Visible Property
The Worksheet.Copy Method
The Worksheet.Delete Method
The Worksheet.Move Method
Range References
The Range.Select Method
The Value vs. Text Properties
R1C1 Notation, Part I
R1C1 Notation, Part II
The Formula and FormulaR1C1 Properties
The Range.Offset Property
The Range.Resize Property
The Cells Property
The Range.CurrentRegion Property
The Range.End Property
The Range.Count and Range.CountLarge Properties
The Range.Row and Range.Column Properties
The Range.Rows and Range.Columns Properties
The Range.EntireRow and Range.EntireColumn Properties
Get Last Row of Data in Worksheet
Range Actions
The Range.FillDown Method
The Range.Replace Method
The Range.TextToColumns Method
The Range.Worksheet Property
The Range.Sort Method
The Range.Font Property
The Range.Interior Property
The Range.ColumnWidth and Range.RowHeight Properties
The Range.AutoFit Method
The Range.Clear, Range.ClearContents and Range.ClearFormats Methods
The Range.Delete Method
The Range.Copy and Range.Cut Methods
The Paste and PasteSpecial Methods on the Worksheet Object
The Parent Property on All Objects
Conditionals
Boolean Expressions
The If Then Statement
The ElseIf and Else Statements
Select Case
The AND & OR Logical Operators
The NOT Operator
Iteration
The For Next Loop
The Step Keyword
Deleting Rows
The For Each-Next Construct
Iterating over a Range of Cells with For Each
The With-End With Construct
Exit For and Review of Exit Sub
Miscellaneous Features
The MsgBox Method In Depth, Part I
The MsgBox Method In Depth, Part II
StatusBar
The Application.ScreenUpdating Property
SpecialCells
The InputBox Function
The Application.InputBox Method
Arrays
Intro to Arrays
Alternate Syntax for Fixed-Size Arrays
The Option Base 1 Syntax and Write Array Values to Cells
Initialize Arrays within a For Loop
The LBound and UBound Methods
Dynamic Arrays
The Range.RemoveDuplicates Method
Functions
VBA Functions, Part I
VBA Functions, Part II
The Split Function
The Is Family of Functions
Date and Time Functions
More Date and Time Functions
Excel Worksheet Functions
Custom Functions
Debugging
Intro to Error Handling
The OnError and GoTo Keywords
The OnError Resume Next Keywords
Error and Err.Number
Stepping Through Code
Breakpoints
Events
Introduction to Events
The Worksheet_SelectionChange Event
Review of Application.EnableEvents
The Worksheet_Change Event
The Worksheet_Activate Event
Workbook Events and The Sh Argument
The Workbook_Open Event
Procedures with Boolean Arguments + The Workbook_BeforePrint Event