Your first reaction might be to wonder why you'd ever need to create yet another object in Excel, which seemingly has no shortage of objects. Though you won't need class modules for most of your projects, this lesson helps you recognize when the time is right to use class modules, and most importantly, how to program them.Ī class is the formalized definition of an object that you create.

Here is an opportunity for you to set yourself apart from the VBA crowd and learn a valuable skill that has actually been available in Excel since Office 97. Provide examples of class modules applied to UserForm and embedded worksheet controls.Describe what class modules can do for you.Explain what classes and class modules are.I want to express three objectives in this lesson: For some reason, the use of class modules is not a skill held by many otherwise knowledgeable VBA programmers, despite the power and flexibility class modules can provide to your workbook projects.Ĭlass modules are not rocket science, but they are a different kind of VBA animal that takes some extra attention to grasp. Excel VBA 24-Hour Trainer (2015) Part IV Advanced Programming Techniques Lesson 24 Class ModulesĬlass modules-the very name has caused many a burgeoning Excel VBA programmer to turn toward other areas of VBA study.

Class module in excel vba examples