How to use Class Modules with the VBA Dictionary

👉 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/3CHIuYn (Note: If the download page doesn't work then make sure to turn off any popup blockers) How to use Class Modules with the VBA Dictionary In this video I'm going to show you how and why to use Class Modules with the VBA Dictionary. We're going to looks under the hood and see exactly how Class Modules work in VBA. We're then going to do a full VBA example. Finally I'm going to show you how you can avoid the issues with external libaries by getting the Collection to work exactly like a Dictionary #VBADictionary #ClassModule #VBACollection Useful VBA Shortcut Keys ======================== Debugging: Compile the code: Alt + D + C 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)

• #science_technology
• #classmodules_vbadictionary_vbacollection_excelvba_vba