Chapter 1: Getting Started with VBA

The recipes in this chapter will help you familiarize yourself with VBA in general, introduce you to the VBA working environment, and also help you edit and save your first working VBA subroutine. In the process, you will learn how to set up the development environment and how to edit your VBA coding.

In this chapter, we will cover the following recipes:

• Investigating VBA code
• Recording a macro
• Testing the macro
• Using the VBA Editor
• Editing the code by changing cell references
• Saving the file with an embedded macro
• Using the Trust Center for macro security
• Creating a customized ribbon

By the end of this chapter, you will be able to identify the need and use for a macro, record a macro, edit VBA code, and save the macro in an Excel Workbook.