Business Solutions VBA for the 2007 Microsoft Office System

4Building VBA Expressions

IN THIS CHAPTER

Understanding Expressions

Working with VBA Operators

Understanding Operator Precedence

Working with Numeric Expressions

Working with String Expressions

Working with Logical Expressions

Working with Date Expressions

The VBA variables you learned about in the Chapter 3, “Understanding Program Variables,” don’t amount to a hill of beans unless you do something with them. In other words, a procedure or function is merely a lifeless collection of Dim statements until you define some kind of relationship among the variables and your program objects. (I’ll talk about the latter in Chapter 5, “Working with Objects.”)

To establish these relationships, you need to create expressions that perform calculations ...