Excel 2016 VBA and Macros

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

Next Steps

I Can’t Understand This Code

As mentioned in Chapter 1, “Unleashing the Power of Excel with VBA,” 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:

Click here to view code image ...