Скачать с ютуб Class Modules in VBA: Made Super Simple в хорошем качестве

Class Modules in VBA: Made Super Simple

👉 Ready to master VBA? - Check out my full courses: https://courses.excelmacromastery.com/ - Subscribe to the channel here: https://bit.ly/36hpTCY -Want to download the source code for this video? Go here: https://bit.ly/3UVeZMR (Note: If the download page doesn't work then make sure to turn off any popup blockers) Class Modules in VBA: Made Super Simple Class Modules are the biggest stumbling block for users trying to move to the next level in VBA. Many people struggle to grasp what they are for, when to use them and how to use them in their own code. In this video I am going to show you with real-world examples, How any one can use Class Modules in their code. #ExcelVBA #VBAClassModules #ClassModules Useful VBA Shortcut Keys ======================== Debugging: Compile the code: Alt + D + L OR Alt + D + Enter Run the code from the current sub: F5 Step into the code line by line: F8 Add a breakpoint to pause the code: F9(or click left margin) Windows: View the Immediate Window: Ctrl + G View the Watch Window: Alt + V + H View the Properties Window: F4 Switch between Excel and the VBA Editor: Alt + F11 View the Project Explorer Window: Ctrl + R Writing Code: Search keyword under cursor: Ctrl + F3 Search the word last searched for: F3 Auto complete word: Ctrl + Space Get the definition of the item under the cursor: Shift + F2 Go to the last cursor position: Ctrl + Shift + F2 Get the current region on a worksheet: Ctrl + Shift + 8(or Ctrl + *) To move lines of code to the right(Indent): Tab To move lines of code to the left(Outdent): Shift + Tab Delete a Line: Ctrl + Y(note: this clears the clipboard) Table of Contents: 00:00 - Introduction 01:00 - Bank Account example 02:58 - Issues with Standard VBA code 03:05 - Using a Class Module for Account 10:49 - The Elements of a Class Module 13:37 - How to use Set and New 14:45 - Guidlines for creating Class Modules 15:43 - Collection Example