Excel VBA Programming Online Course

Excel VBA Programming Online Course

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!

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

User Forms

• Create UserForm, Toolbox, Properties, Controls
• The Label and TextBox Controls
• Naming Conventions
• Design Aesthetics
• The CommandButton Control
• Add Event Procedure to Control
• Unload and Hide a UserForm
• Submit the UserForm
• Activate a UserForm from Procedure
• The initialize Event
• The ListBox Control I - Wire up the Form
• The ListBox Control II - React to User Selection
• The ListBox Control III - Select Multiple Items
• The ComboBox Control I
• The ComboBox Control II
• The CheckBox Control