Summary

In this chapter, you've learned a lot about the foundations and basic units of programming – making choices in code, branching, functions and procedures, and seeing how to lace all of these parts together into functional code. These techniques have been around since the very early days of programming, and you'll be using them in every program you write.

The topics we covered include:

• How we can define and use functions and procedures to group tasks together

• How to write If ... Then ... End If statements

• How to make more complex choices using Else and ElseIf

• How to make decisions that depend on more than one condition

• How to write more elegant and readable code for multiple decisions based on the value of one condition by using a Select ... Case Statement

• How to use a For loop to run parts of your program a certain number of times

• How to use Do loops, and the significance of the While and Until clauses

• How to nest one block of code inside another

In the next chapter, we'll learn about storing different types of data. You've already seen Dim statements here and there, and played around with numbers and text in this and the previous chapters, but now you'll learn exactly how to use the different data types available to you in your applications.