Chapter 42: Introducing Visual Basic for Applications
42
FIGURE 42.13
The ListFormulas macro creates a list of all formulas in a worksheet.
Learning More
This chapter is a basic introduction to VBA. If this is your first exposure to VBA, you might
be a bit overwhelmed by objects, properties, and methods. It’s frustrating when you know
what you want to do but don’t know which objects, properties, or methods you need to
do it. Fortunately, several good ways are available to learn about objects, properties, and
methods.
Read the rest of the book Subsequent chapters in this section contain additional infor-
mation and many more examples.
Record your actions The best way to become familiar with VBA is to turn on the macro
recorder and record the actions you make in Excel. You can then examine the code to gain
some insights regarding the objects, properties, and methods.