From the course: Excel VBA: Process Modeling
Join today to access over 24,900 courses taught by industry experts.
Run the simulation - Microsoft Excel Tutorial
From the course: Excel VBA: Process Modeling
Run the simulation
- [Instructor] In this chapter, you have added code to your simulation module to manage a business process by creating a timer. At each click of the timer or tick of the clock, your VBA code updates the status of each customer and station, moving customers through stations at the appropriate times. In this movie, you will run the simulation and take a look at the results that have been sent to the immediate window. The sample file is Chapter 0305, and you can find that in the Chapter Three folder of the Exercise Files collection. We don't need to work with any of the data on the Sim Setup worksheet directly. So I'll press Alt + F11 to move to the Visual Basic Editor. And here is my code module. I'll click in the body of the subroutine. And I don't see the immediate window displayed, so I'll press Ctrl + G to display it. And there it is at the bottom. So, now, I can click back in the body of the subroutine and press F5 to run my code and hopefully I'll get updates on each 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.
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.