Excel 2007 VBA Programming with XML and ASP

Chapter 6Chapter 6

Decision Making

with VBA

Relational and Logical Operators + If …Then Statement

+ Decisions Based on More Than One Condition + If

Block Instructions and Indenting + If…Then…Else

Statement + If…Then…ElseIf Statement + Nested

If…Then Statements + Select Case Statement + Using

Is with the Case Clause + Specifying a Range of Values in

a Case Clause + Specifying Multiple Expressions in a

Case Clause + Chapter Summary

163

We make thousands of decisions every day. Some decisions are spontaneous;

we make them automatically without having to stop ...