Dive into the world of Visual Basic for Applications (VBA) in Excel 2019 with this comprehensive beginner tutorial. Learn to automate repetitive processes, build custom tools, and unlock new possibilities in Excel. Start by understanding VBA basics, adding the Developer tab, and recording macros. Progress to editing VBA code, exploring the Visual Basic Editor, and customizing settings. Master the Excel Object Model hierarchy, create various types of procedures and functions, and understand their scope. Discover how to reference objects, use the Properties window, and save macro-enabled workbooks. Practice creating and modifying sub-procedures, calling procedures, and developing user-defined functions. By the end of this 2-hour 11-minute tutorial, gain the foundational skills to write your own VBA code and enhance your Excel capabilities for data analysis and business tasks.
Overview
Syllabus
Start
Introduction
Getting Started
VBA Overview
Adding the Developer Tab to the Excel Ribbon
Record Macro Dialog Box
Recording Macros
Testing Macros
Visual Basic Editor Overview and Changing Font Settings
Customizing VBE Toolbar
Editing VBA Code Generated by Recording a Macro
Using the Properties Window to Rename Objects
Saving Macro-Enabled Workbooks
Testing Macro Changes in Another Excel File
Undoing Macro Steps and Modifying Trust Center Settings
Getting Started Recap
Excel Object Model Hierarchy Overview and Collections
Referencing Objects
Introduction to Procedures and Functions
Understanding Module and Procedure Types
Naming Rules and Conventions for Procedures
Starting Macro Recordings from the Status Bar
Creating a Macro that Copies Data from Another File into the Current File
Reviewing Methods and Examples
Reviewing Newly Generated Code
Creating a Sub-Procedure from Scratch Using the Insert Menu
Modifying Two Existing Sub-Procedures
Executing Procedures and Creating a Calling Procedure from Scratch
Understanding the Scope of Procedures
Testing Calling Procedures
Creating Event Procedures
Testing Calling Procedures
Creating Function Procedures
Testing Function Procedures in the Immediate Window
Testing Function Procedures in Excel - User Defined Function
Accessing Context Specific Help from VBE
Procedures and Functions Recap
Conclusion
Taught by
Learnit Training
