Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365)

Chapter 2

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

In this chapter, you will:

• Find out how VBA is different from 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 ...