Excel Workbook For Dummies, 2nd Edition

Chapter 22

Using the Visual Basic Editor

IN THIS CHAPTER

Getting familiar with the Visual Basic Editor

Editing a macro in the Visual Basic Editor

Adding interactivity to a macro with a dialog box that processes user input

Creating and using user-defined functions in the Visual Basic Editor

Saving user-defined functions as Excel add-ins

Visual Basic for Applications (usually known simply as VBA) is the official programming language of Excel that you can use to edit as well as to write new macros. The key to editing and writing macros in Visual Basic for Applications is its editing program, the Visual Basic Editor (often abbreviated VBE). The Visual Basic Editor offers a rich environment for writing and debugging VBA.

In this chapter, you use the Visual Basic Editor to edit macros that you’ve recorded (see Chapter 21) as well as to enhance their basic functionality through the addition of interactivity. In addition, you use the VBE to create your own custom functions known as user-defined ...