Chapter 3: Creating Code

Overview

Well, we really should start looking deeper at some code. The next two chapters are going to lay the foundations of programming and using VBA. So far, we've looked at the programming environment, and seen how event-driven programming works, so now it's time to start putting this into practice.

In this chapter we will be dealing with what code is, and how you can build up code in small segments to make programming easier. In particular we shall look at:

• What procedures are and how you use them

• How to pass information into procedures

• What variables are and how they store data

• The different types of data you can store

• How to make decisions in your code

This is the heart of the VBA language, and will lay the foundations for all programming you do later.