This advanced Excel VBA tutorial aims to teach learners how to automate repetitive processes and build tools in Excel using Visual Basic for Applications (VBA). By the end of the course, students will be able to write their own VBA code, modify recorded macros, create efficiency in daily tasks, control program flow, create forms and controls, and programmatically create Pivot Tables. The course is designed for Business Analysts, Data Scientists, and individuals looking to enhance their Excel skills. The teaching method includes a 4-part series covering key VBA concepts, terminology, procedures, language elements, control-of-flow structures, forms, Pivot Tables, debugging, and error-handling.
Overview
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
Taught by
Learnit Training
