Control Flow and Decision-Making in Excel VBA

The main purpose of is to help you:

• Specify a procedure's control flow; and
• Create procedures that make decisions.

The ability to do the above:

• Allows you to create even more powerful procedures; and
• Explains a substantial part of VBA's power.

:

• Is part of my Book Series; and
  
• Assumes you know about the topics covered in: (i) My previous Book Series, particularly the Book Series; and (ii) The previous Books in the Book Series.
  

is divided into six Chapters.

• Chapter 1 is an introduction to the concept of control flow in VBA.
• In Chapter 2, you learn how to work with: (i) Labels; and (ii) The GoTo statement.
• In Chapter 3, you learn how to work with: (i) Logical expressions; and (ii) Conditional tests.
• In Chapter 4, you learn how to work with: (i) The If… Then… Else statement; and (ii) The IIf VBA built-in function.
• Chapter 5 contains examples to help you practice working with the If… Then… Else statement.
• In Chapter 6, you learn how to work with the Select Case statement.