Part III

Programming Concepts

Check out the video instruction for applying Excel functions at www.dummies.com/extras/excelvbaprogramming.

In this part . . .

Discover the essential elements of Excel programming: variables, constants, data types, operators, arrays, and so on

Get acquainted with Range objects — you’ll be glad you did

Find out why VBA functions (and also Excel worksheet functions) are important

Discover the essence of programming: decision-making and looping

See how to run code automatically when certain things occur

Find out about the different types of errors and why error handling is important

Know what to do when good code does bad things: Get initiated into the bug extermination club

See lots and lots of examples — some are mainly informative, and many are actually useful

Check out the video instruction for applying Excel functions at www.dummies.com/extrasexcelvbaprogramming.