Home / MS-Excel / General Formatting

Controlling Your VBA Code

One of the advantages of writing your own VBA procedures instead of simply recording them is that you end up with much more control over what your code does and how it performs its tasks.
In particular, you can create procedures that make decisions based on certain conditions and that can perform loops-the running of several statements repeatedly.
The statements that handle this kind of processing-control structures-are the subject of this tutorial.

In this tutorial:

  1. Code That Makes Decisions
  2. Using If...Then to Make True/False Decisions
  3. Using If Then Else to Handle a False Result
  4. Making Multiple Decisions
  5. Using the Select Case Statement
  6. Functions That Make Decisions
  7. Code That Loops
  8. Using Do..Loop Structures
  9. Using For...Next Loops
  10. Using For Each...Next Loops
  11. Using Exit For or Exit Do to Exit a Loop
  12. Indenting for Readability