Excel 2021 VBA Beginner Tutorial

Excel 2021 VBA Beginner Tutorial

Learnit Training via YouTube Direct link

Start

1 of 35

1 of 35

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

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.