Excel VBA Programming Course

Lesson 1 • Variables, Data Types, and Constants

Teaches declaration syntax, common data types, and named constants. Proper typing prevents runtime errors covered in later chapters.

Lesson 2 • Navigating the VBA Editor

Covers the Visual Basic Editor interface, project explorer, and properties window. Establishes the workspace students use throughout the entire course.

Lesson 3 • Core VBA Syntax Rules

Introduces statements, keywords, comments, and line continuation. Provides the grammatical foundation required for every subsequent coding task.

Lesson 4 • Operators and Expressions

Explains arithmetic, comparison, logical, and string operators with precedence rules. Students combine operators to form expressions used in all control structures ahead.

Lesson 1 • Select Case Structures

Introduces Select Case as a cleaner alternative to long ElseIf chains. Students apply it to multi-branch decisions on numeric and string values.

Lesson 2 • Do-While and Do-Until Loops

Covers condition-driven loops for scenarios where iteration count is unknown. Students choose the correct loop type based on data structure.

Lesson 3 • Error Handling Basics

Introduces On Error GoTo and On Error Resume Next for graceful failure management. Establishes defensive coding habits reinforced throughout the course.

Lesson 4 • If-Then-Else Statements

Covers single-line and block If structures, ElseIf chains, and nested conditions. Builds the primary decision-making tool used in all subsequent projects.

Lesson 1 • Sub Procedures in Depth

Explains Sub declaration, calling conventions, and procedure scope modifiers. Establishes the primary code unit students build on throughout the course.

Lesson 2 • Working with Arrays

Introduces fixed and dynamic arrays, multi-dimensional arrays, and array functions. Arrays are the primary data structure for high-performance bulk operations ahead.

Lesson 3 • Function Procedures and Return Values

Covers Function syntax, return value assignment, and use as worksheet formulas. Students create custom functions that extend Excel's built-in formula library.

Lesson 4 • Variable Scope and Lifetime

Distinguishes local, module-level, and global variable scope and their lifetimes. Prevents the data-leakage bugs common in multi-procedure projects.

Lesson 1 • Reading and Writing Cell Data

Covers Value, Value2, Text, and Formula properties for reading and writing cell content. Students transfer data between ranges and variables efficiently.

Lesson 2 • Range Object and Cell References

Explores Range, Cells, Rows, and Columns objects with multiple reference methods. Precise cell targeting is the foundation of all data manipulation tasks.

Lesson 3 • Worksheet Object Operations

Teaches adding, deleting, renaming, and protecting worksheets programmatically. Students control sheet structure as a prerequisite for range automation.

Lesson 4 • Application and Workbook Objects

Covers the Application object properties and Workbook collection methods for opening, saving, and closing files. Establishes the top two levels of the object hierarchy.

Lesson 1 • MsgBox and InputBox Functions

Covers MsgBox button constants, return values, and InputBox data capture. These built-in dialogs provide quick interaction without custom form design.

Lesson 2 • Dynamic and Multi-Page Forms

Builds multi-page forms and dynamically adds or hides controls at runtime. Students handle complex data-entry workflows within a single form interface.

Lesson 3 • UserForm Design Fundamentals

Introduces the UserForm designer, toolbox controls, and property settings. Students create the visual layout that hosts interactive controls in later sections.

Lesson 4 • Common Form Controls

Teaches TextBox, ComboBox, ListBox, CheckBox, and OptionButton configuration. Each control type maps to a specific data-entry scenario students will encounter.

Lesson 1 • Finding and Replacing Data

Uses Find, FindNext, and Replace methods to locate and update cell values at scale. Students build search utilities that replace manual Ctrl+F workflows.

Lesson 2 • Working with Tables and ListObjects

Introduces the ListObject model for structured table manipulation in VBA. Tables provide dynamic range references that simplify data-processing code.

Lesson 3 • Data Validation and Cleansing

Automates detection and correction of blanks, duplicates, and format inconsistencies. Clean data is a prerequisite for the reporting and analysis macros ahead.

Lesson 4 • Sorting and Filtering Data

Covers the Sort and AutoFilter methods with dynamic criteria built from variables. Automates data preparation steps that precede analysis and reporting.

Lesson 1 • File System Operations

Covers Dir, FileSystemObject, and file dialog methods for navigating and managing files. Enables macros that process batches of external files automatically.

Lesson 2 • Database Connectivity with ADO

Introduces ActiveX Data Objects for querying databases directly from VBA. Students retrieve and write structured data without leaving the Excel environment.

Lesson 3 • Reading and Writing Text Files

Uses Open, Print, Write, and Line Input statements for CSV and flat-file I/O. Students import raw data files and export processed results programmatically.

Lesson 4 • Importing External Workbooks

Automates opening, reading, and closing external Excel files without user interaction. Supports the batch consolidation workflows introduced in the previous chapter.

Lesson 1 • Workbook and Worksheet Events

Covers Workbook_Open, SheetChange, and BeforeSave events for trigger-based automation. Students build self-activating solutions that respond to user actions.

Lesson 2 • Performance Optimization Strategies

Applies screen updating, calculation mode, and array-based I/O to maximize macro speed. Students reduce execution time of data-heavy macros by orders of magnitude.

Lesson 3 • Class Modules and Custom Objects

Builds custom classes with properties, methods, and events using class modules. Object-oriented design makes complex solutions maintainable and extensible.

Lesson 4 • Advanced Error Handling Patterns

Implements centralized error handlers, custom error numbers, and error-log files. Builds production-quality resilience beyond the basic error handling introduced earlier.