Class Modules Explained in Simple English (with examples)

Class Modules Explained in Simple English (with examples)

In this video I explain what VBA Class Modules are and how you can use them. Classes can be a tricky topic to understand so I've done my best to explain them as simply as possible with lots of examples.

I have also included 2 real-world uses of Class Modules so you can see the advantage of using them.

If you have any questions or comments please leave them below the video.

FREE CHEAT SHEET: Get the free cheat sheet on VBA arrays here: (https://bit.ly/2MXsnz9)

Learn how to build 10 full Excel VBA applications from scratch: The Excel VBA Handbook Course(https://TheExcelVBAHandbook.com)

Related Links:
VBA Class Modules – The Ultimate Guide (https://excelmacromastery.com/vba-class-modules/)
VBA Objects – The Ultimate Guide (https://excelmacromastery.com/vba-objects/)

Related Webinar Replays(VBA Vault Members only):
Class Modules Advanced (https://excelmacromastery.com/class-modules-interfaces-live-webinar/)
Class Modules – Interfaces (https://excelmacromastery.com/class-modules-interfaces-video/)
VBA Class Modules – The Ultimate Guide (https://excelmacromastery.com/class_module_video/)
Free Excel VBA Resources
Excel VBA Articles (https://excelmacromastery.com/vba-articles/)

Useful VBA Shortcut Keys:
Tab: To move lines of code to the right(Indent).
Shift + Tab: To move lines of code to the left(Outdent).

Shift + F2: Get the definition of the item under the cursor.
Ctrl + Shift + F2: Go to the last cursor position.
Ctrl + Space: AutoComplete Word.
Alt + F11: Switch between Excel and the VBA Editor.
Ctrl + R: View the Project Explorer Window.
Ctrl + Shift + 8(or Ctrl + *): Get the current region on a worksheet.
F4: View the Properties Window.
F5: Run the code from the current sub.
F9(or click left margin): Add a breakpoint to pause the code.

Видео Class Modules Explained in Simple English (with examples) канала Excel Macro Mastery