Chapter 2

VBA Programming

IN THIS CHAPTER

Bullet Getting familiar with Visual Basic for Applications and the Visual Basic Editor

Bullet Editing and running a macro in the Visual Basic Editor

Bullet Creating a dialog box that prompts you for input for your macro

Bullet Writing new macros in the Visual Basic Editor

Bullet Using VBA to create user-defined functions

Bullet Using your user-defined functions in your worksheets

Bullet Saving user-defined functions as Excel Add-ins

The subject of this chapter is Visual Basic for Applications (usually shortened to VBA), which is the official programming language of Excel (and the other main Office apps), and how you can use it to edit the macros that you record (as described in Book 8, Chapter 1) as well as to write new macros. The key to editing and writing macros in VBA is its editing program, ...

Get Excel All-in-One For Dummies 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.