From the course: Excel VBA: Process Modeling
Join today to access over 25,300 courses taught by industry experts.
Add instructions within the framework - Microsoft Excel Tutorial
From the course: Excel VBA: Process Modeling
Add instructions within the framework
- [Instructor] In the previous movie, we added the framework of if and for next statements that we will use to manage the movement of customers through a series of stations in a business process. In this movie, we will fill in the detailed instructions for the if statements, so the process will move customers to the next available station at the appropriate tick of the clock. My sample file is Chapter 0303. And that's an Excel workbook that you can find in the chapter three folder of the exercise files collection. We won't do anything with the data on the SIM setup worksheet, so I will press Alt F11. To move to the visual basic editor. And I will. Increase the size. Of the code window. I'm going to scroll down. Almost all the way to the bottom. And we will start from where I have the L ticker variable. Which is the clock that we used to track actions within our simulated process. So I have my comments that tell me where to add items, so the first action will be to add one to customer…
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.