From the course: Excel VBA: Process Modeling

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Define the Customers class and add a customer

Define the Customers class and add a customer

From the course: Excel VBA: Process Modeling

Start my 1-month free trial

Define the Customers class and add a customer

“

- [Instructor] In this course of simulations, we are modeling the flow of customers through a sandwich shop. This process has two main elements, customers and stations. In this movie, I will review the structure of the customers class, and then I'll use VBA to create an instance of a customer object, and add the customer object to the customers collection. My sample file is Chapter 0203, and that's a workbook you can find in the Chapter 2 folder of the exercise files collection. The data on the sim setup worksheet all refers to stations, which we won't be addressing in this movie, so I'll press Alt + F11 to move directly to the Visual Basic Editor. In the Visual Basic Editor, I have arranged the windows so that the customer class module is in front. That way we can scroll through and review its structure, although in this case I'll just remind you that we have six variables that are represented by properties.…

Contents