Subtitles of the Movie

So with Control Structures, we've come to the point where VBA's capabilities really outshine those of native Excel, because we get here where we can act more like a user in moving between cells and creating actions, which we will really just can't do using Excel by itself. And using the Control Structures provides us with greater adaptability to circumstances. We can loop according to the number of objects in the collection for example, and that can change, and our code will still run correctly, no matter how many objects there are. Then there's particular conditions are met, and we can execute particular code in response to that. But also there is a drawback in that the level of complexity goes up. So we have to be more careful to plan out our code and to document it. And we need to make use of the facilities such as the Watch window and the Locals window that are part of the Visual Basic editor in order to track what's going on, and to troubleshoot code that's not working as it should. So take your time to test the code thoroughly under all possible operating conditions. Let's move now to interacting with users.