MS-Excel / General Formatting

Code That Makes Decisions

A smart procedure performs tests on its environment and then decides what to do next based on the results of each test. For example, suppose you've written a Function procedure that uses one of its arguments as a divisor in a formula. You should test the argument before using it in the formula to make sure that it isn't 0 (to avoid producing a "Division by zero" error). If it is, you could then display a message that alerts the user of the illegal argument. Similarly, a well-designed application will interact with the user and ask for feedback in the form of extra information or a confirmation of a requested action. The program can then take this feedback and redirect itself accordingly.

[Contents] [Next]

In this tutorial:

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