Excel 2021 VBA Advanced Tutorial

This advanced course teaches Excel VBA for automating tasks and building tools. It covers the Excel object model, procedures, variables, control flow, UserForms and controls, recorded and edited macros, debugging, error handling, and programmatic PivotTables.

Syllabus

Start
Introduction
Introduction to Forms and Controls
Form Properties, Methods, and Events
Inserting and Modifying UserForm Objects
Using Label Control on Forms
Using Textbox Control on Forms
Using Command Button Control on Forms
Using Combo Box Control on Forms
Using Frame Control on Forms
Using Option Button Control on Forms
Changing Option Button Properties
Formatting Form Controls
Testing and Modifying Tab Order on Forms
Using Code to Populate Combo Boxes and Setting Defaults
Modifying Combo Box Code and Inserting Control Code Files
Reviewing Inserted Code
Testing Modified and Inserted Code
Writing Code to Display Forms
Forms and Controls Recap
Introduction to Pivot Tables in VBA
PivotCache, PivotTable, and PivotFields Objects
Recording Macros to Create PivotCache
Recording Macros to Set Pivot Table Fields
Reviewing Macro Codes
Creating Pivot Tables Programmatically
Creating Code to Set Pivot Table Fields
Finalizing Forms
Reviewing Inserted Code
Finalizing Code
Creating and Modifying Function Procedures
Testing Forms
Adding QAT Icon to Launch Form
Testing Final Forms
Pivot Tables in VBA Recap
Conclusion