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.
Run the simulation
- [Instructor] In this chapter, you've added code to your simulation module to manage a business process by creating a timer. At each tick of the timer, your VBA code updates the status of each customer and station, moving customers among stations at the appropriate times. In this movie, you will run the simulation based on the code we've already created, and take a look at the results that your code sends to the Immediate Window. My sample file is Chapter03_05, and you can find it in the chapter 3 folder of your exercise files collection. We don't need to make any changes to the SimSetup worksheet. So, I'll press Alt + F11 to move to the Visual Basic editor. Our code is complete, but I do need to display the Immediate Window, because that's where the results are going to be displayed. To open the Immediate Window, I'll press Ctrl + G, and there it is. Now, I'll go back and, in the code module, click inside of the…
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.