VBA and Macros for Microsoft Excel

2This Sounds Like BASIC, So Why Doesn't It Look Familiar?

IN THIS CHAPTER

I Can't Understand This Code

Understanding the Parts of VBA “Speech”

Is VBA Really This Hard? No!

Examining Recorded Macro Code—Using the VB Editor and Help

Using Debugging Tools to Figure Out Recorded Code

The Ultimate Reference to All Objects, Methods, Properties

Five Easy Tips for Cleaning Up Recorded Code

Putting It All Together—Fixing the Recorded Code

Case Study

Next Steps

I Can't Understand This Code

As I mentioned before, if you've taken a class in a procedural language such as BASIC or COBOL, then you might be really confused when you look at VBA code. Yes, VBA stands for “Visual Basic for Applications,” but it is an object-oriented version of ...