Completed
Start
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel 2021 VBA Beginner Tutorial
Automatically move to the next video in the Classroom when playback concludes
- 1 Start
- 2 Introduction
- 3 VBA Basics
- 4 Getting Started
- 5 Example of Object-Oriented Programming Using Excel
- 6 Why VBA?
- 7 VBA vs Macros
- 8 Adding the Developer Tab to the Ribbon
- 9 Filling in the Record Macro Dialog
- 10 Recording Macros
- 11 Testing Macros
- 12 Exploring VBE
- 13 Viewing VBE Options and Reviewing Macro Code
- 14 Editing Macro Code and Using Project Explorer and Properties
- 15 Adding Useful Commands to the Toolbar
- 16 Saving Macro-Enabled Workbooks
- 17 Testing Edited Macros
- 18 Reviewing and Changing Security Settings
- 19 VBA Basics Recap
- 20 Excel Object Model Hierarchy and Collections
- 21 Referencing Objects and Simplifying Object References
- 22 Introduction to Modules and Procedures
- 23 Understanding Modules
- 24 Understanding Procedures
- 25 Recording More Macros
- 26 Creating Sub-Procedures from the Menu in VBE
- 27 Reviewing New Code and Editing Existing Code
- 28 Creating Calling Procedures
- 29 Testing Calling Procedures
- 30 Creating Event Procedures
- 31 Creating Function Procedures
- 32 Reviewing and Testing Function Procedures
- 33 Getting Context Sensitive Help in VBE
- 34 Modules and Procedures Recap
- 35 Conclusion