From the course: Excel VBA: Process Modeling
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Define class properties
- [Instructor] After you create a class in Excel VBA, you can define variables called properties that contain values describing the object. For example, you could create a class that represents work stations within a business. Each station would have values for properties including the station's identification number, average processing time, standard deviation of processing time, and the next station in the process, if any. In this movie, I will show you how to work within the code module to define variables and also start creating class properties for your objects. My sample files, Chapter01_02 and you can find it in the Chapter One folder of your exercise files collection. We won't be doing any work with the worksheet in this workbook so I'll press Alt + F11 to switch to the visual basic editor. In this workbook, I have defined a class module for customers and to indicate that it is a class module, I have named it…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.