Chapter 2

VBA Programming

IN THIS CHAPTER

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

check Editing a macro in the Visual Basic Editor

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

check Writing new macros in the Visual Basic Editor

check Using VBA to create user-defined functions

check Using your user-defined functions in your spreadsheets

check Saving user-defined functions as Excel Add-ins

The subject of this chapter is Visual Basic for Applications (usually known simply as VBA), which is the official programming language of Excel, 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, the Visual Basic Editor (often abbreviated ...

Get Excel 2019 All-in-One For Dummies now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.