Dive into a comprehensive beginner tutorial on Excel 2021 VBA, designed for Business Analysts, Data Scientists, and Excel users seeking to automate tasks and expand their capabilities. Learn the fundamentals of Visual Basic for Applications, starting with an overview of its advantages over traditional macro recording. Record and edit macros, explore the Visual Basic editor environment, and understand key terminology. Discover the Excel Object Model, collections, and object referencing techniques. Master different types of procedures, their scope, and working with methods. Delve into VBA language elements, including variables, data types, and intrinsic functions. Explore control-of-flow structures, create forms, and program controls. Learn to create Pivot Tables programmatically and handle code errors through debugging. By the end of this 1-hour 48-minute tutorial, gain the skills to write custom VBA code, modify recorded macros, and enhance your daily Excel tasks with increased efficiency.
Overview
Syllabus
Start
Introduction
VBA Basics
Getting Started
Example of Object-Oriented Programming Using Excel
Why VBA?
VBA vs Macros
Adding the Developer Tab to the Ribbon
Filling in the Record Macro Dialog
Recording Macros
Testing Macros
Exploring VBE
Viewing VBE Options and Reviewing Macro Code
Editing Macro Code and Using Project Explorer and Properties
Adding Useful Commands to the Toolbar
Saving Macro-Enabled Workbooks
Testing Edited Macros
Reviewing and Changing Security Settings
VBA Basics Recap
Excel Object Model Hierarchy and Collections
Referencing Objects and Simplifying Object References
Introduction to Modules and Procedures
Understanding Modules
Understanding Procedures
Recording More Macros
Creating Sub-Procedures from the Menu in VBE
Reviewing New Code and Editing Existing Code
Creating Calling Procedures
Testing Calling Procedures
Creating Event Procedures
Creating Function Procedures
Reviewing and Testing Function Procedures
Getting Context Sensitive Help in VBE
Modules and Procedures Recap
Conclusion
Taught by
Learnit Training
