Completed
Start
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel 2019 VBA Beginner Tutorial
Automatically move to the next video in the Classroom when playback concludes
- 1 Start
- 2 Introduction
- 3 Getting Started
- 4 VBA Overview
- 5 Adding the Developer Tab to the Excel Ribbon
- 6 Record Macro Dialog Box
- 7 Recording Macros
- 8 Testing Macros
- 9 Visual Basic Editor Overview and Changing Font Settings
- 10 Customizing VBE Toolbar
- 11 Editing VBA Code Generated by Recording a Macro
- 12 Using the Properties Window to Rename Objects
- 13 Saving Macro-Enabled Workbooks
- 14 Testing Macro Changes in Another Excel File
- 15 Undoing Macro Steps and Modifying Trust Center Settings
- 16 Getting Started Recap
- 17 Excel Object Model Hierarchy Overview and Collections
- 18 Referencing Objects
- 19 Introduction to Procedures and Functions
- 20 Understanding Module and Procedure Types
- 21 Naming Rules and Conventions for Procedures
- 22 Starting Macro Recordings from the Status Bar
- 23 Creating a Macro that Copies Data from Another File into the Current File
- 24 Reviewing Methods and Examples
- 25 Reviewing Newly Generated Code
- 26 Creating a Sub-Procedure from Scratch Using the Insert Menu
- 27 Modifying Two Existing Sub-Procedures
- 28 Executing Procedures and Creating a Calling Procedure from Scratch
- 29 Understanding the Scope of Procedures
- 30 Testing Calling Procedures
- 31 Creating Event Procedures
- 32 Testing Calling Procedures
- 33 Creating Function Procedures
- 34 Testing Function Procedures in the Immediate Window
- 35 Testing Function Procedures in Excel - User Defined Function
- 36 Accessing Context Specific Help from VBE
- 37 Procedures and Functions Recap
- 38 Conclusion