Following that, we will be moving on to have a look at functions, which is a key part of Excel functionality. And using VBA we can extend functions quite considerably by writing our own user-defined functions, and changing the categorization of functions, and using Excel's built-in functions within our own VBA code. Then it's on to 'code production and management'.

As we start to build up our experience in writing code, we get to the situation where we, we want to better manage what we have, and use it to best advantage. So we will be looking at various different ways of doing that. Back to the worksheet again, and with a detailed look at cell referencing and in particular the range object and the selection object. This chapter also looks at labels and names, which is another important part of cell referencing.Īnd we will be looking at the various ways to identify ranges, return values, and just work with ranges and selections in general. There's various ways that VBA can be used to control execution within Excel, and that's covered in the 'control structures' chapter. We will be looking at various ways of conditional execution of statements, using If statements and select case, and we will be looking at very various looping control structures - the for next loop, the for each next loop, and do loops. Finally, we will be concluding the course with a look at interacting with users, and in particular the message box and the input box.

And how we can protect users from themselves, by using some of the application object's properties to prevent code execution being terminated unnecessarily by the user, or with the user seeing things that don't concern them and so on.

Visual basic for excel