O'Reilly logo

Excel 2013 All-in-One For Dummies by Greg Harvey

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 2: VBA Programming

In This Chapter

arrow.png Getting familiar with Visual Basic for Applications and the Visual Basic Editor

arrow.png Editing a macro in the Visual Basic Editor

arrow.png Creating a dialog box that prompts you for input for your macro

arrow.png Writing new macros in the Visual Basic Editor

arrow.png Using VBA to create user-defined functions

arrow.png Using your user-defined functions in your spreadsheets

arrow.png 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 VIII, 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required