- Chapter 1: Getting Started – Learning About Macros
- 1.1 Introduction
- 1.2 Macros and Visual Basic for Applications
- 1.3 Why Learn Visual Basic for Applications?
- 1.4 Exploring the Developer Tab
- 1.5 Recording a New Macro
- 1.6 Putting It Together: Recording Your First Macro
- 1.7 Running Your Recorded Macro
- 1.8 Saving Your Recorded Macro
- 1.9 Macro Source Code
- 1.10 SummaryThis is the current section.
- 1.11 FAQs
1.10 Summary
In this chapter, you learned what a macro is, and how Visual Basic for Applications (VBA) relates to Excel macros. You learned that adding Visual Basic decision-making and looping structures to recorded macros increases their power (decision-making and looping are the topics of Chapters 13 and 14). By using Visual Basic for Applications, you can create macro programs to suit a wide variety of needs.
More specifically, you learned how to record an Excel macro and how to run a macro that you have recorded. These are the most basic skills you need to get started with VBA. Many of the macros on which you use your VBA programming skills will begin with a macro that you recorded. The next chapter teaches you how to edit a recorded macro.