Mastering VBA for Microsoft Office 2013

Chapter 11

Making Decisions in Your Code

Computers behave intelligently in large part because programming languages include commands that test conditions. Then based on the results of that test, the code jumps (branches) to an appropriate area within the program. This is similar to human decision-making: if it's raining, then take an umbrella. If not, leave it home.

This chapter covers what are called conditional expressions. VBA uses these to create decision structures to direct the flow—the path of execution—of your procedures.

By using decision structures, you can cause your procedures to branch to different sections of code depending on such ...