VBA and Macros: Microsoft® Excel® 2010

2. This 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”

VBA Is Not Really Hard

Examining Recorded Macro Code: Using the VB Editor and Help

Using Debugging Tools to Figure Out Recorded Code

Object Browser: The Ultimate Reference

Seven Tips for Cleaning Up Recorded Code

I Can’t Understand This Code

As mentioned previously, if you have taken a class in a procedural language such as BASIC or COBOL, you might be confused when you look at VBA code. Even though VBA stands for Visual Basic for Applications, it is an object-oriented version of BASIC. Here is a bit of VBA code:

This code likely makes no sense to anyone who knows only procedural languages. Unfortunately, ...