CHAPTER 2This sounds like BASIC, so why doesn’t it look familiar?

In this chapter, you will:

  • Find out how VBA is different than BASIC

  • Understand the parts of VBA “speech”

  • Find out that learning VBA is not really hard

  • Examine recorded macro code using the VB Editor and Help

  • Use debugging tools to figure out recorded code

  • Get to know the Object Browser

  • Learn seven tips for cleaning up recorded 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 ...

Get Microsoft Excel 2019 VBA and Macros, First Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial