Chapter 1

Getting to Know VBA

IN THIS CHAPTER

Bullet Getting a conceptual overview of VBA

Bullet Finding out what you can do with VBA

Bullet Discovering the advantages and disadvantages of using VBA

Bullet Getting the lowdown on what VBA is

Bullet Staying Excel compatible

If you’re eager to jump into VBA programming, hold your horses. This chapter is completely devoid of any hands-on training material. It does, however, contain some essential background information that assists you in becoming an Excel programmer. Just like a great heart surgeon has to take freshman biology, you must learn some basic concepts and terminology so that the more practical aspects you do later make sense.

Understanding VBA Basics

VBA, which stands for Visual Basic for Applications, is a programming language developed by Microsoft — you know, the company that tries to get you to buy a new version of Windows every few years. Excel, along with the other members of Microsoft Office, includes the VBA language (at no extra charge). In a nutshell, ...

Get Excel VBA Programming For Dummies, 6th 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.