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.

Create an outline of If and For Next statements

Create an outline of If and For Next statements

From the course: Excel VBA: Process Modeling

Start my 1-month free trial

Create an outline of If and For Next statements

“

- [Instructor] In this module, you will add a timer or a ticker to your simulation and update each object status with each tick of the clock. For example, suppose a customer will stay at station one until tick 20. With each tick, you must update the clock and check the customer status against that value. If the time is less than 20 ticks, the customer stays at the station. On the 20th tick, the customer must be moved to the next station and the statuses of the customer and station updated appropriately. In this movie, we will create a structure of if and for next statements that will us to manage the ticker and the actions within it. My sample file is chapter 0302 and you can find it in the chapter three folder of the exercise files collection. We won't be doing any work directly with the sim setup worksheet so, I'll press Alt + F11 to go to the Visual basic editor. This code is similar to but slightly different from…

Contents