Business Solutions VBA and Macros for Microsoft® Office Excel® 2007

Chapter 2. This Sounds Like BASIC, So Why Doesn’t It Look Familiar?

IN THIS CHAPTER

I Can’t Understand This Code	29
Understanding the Parts of VBA “Speech”	30
Is VBA Really This Hard? No!	33
Examining Recorded Macro Code—Using the VB Editor and Help	36
Using Debugging Tools to Figure Out Recorded Code	42
The Ultimate Reference to All Objects, Methods, Properties	52
Five Easy Tips for Cleaning Up Recorded Code	54
Putting It All Together—Fixing the Recorded Code	58
Next Steps	60

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, 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 BASIC. Here is a bit ...