Microsoft Excel 2019 VBA and Macros, First Edition

CHAPTER 1Unleashing the power of Excel with VBA

In this chapter, you will:

• Understand the power of Excel

• Learn the barriers to entry of using Excel

• Get to know your tools: The Developer tab

• Understand which file types allow macros

• Be introduced to macro security

• Get an overview of recording, storing, and running a macro

• Find out how to run a macro

• Understand the VB Editor

• Understand the shortcomings of the macro recorder

Visual Basic for Applications (VBA) combined with Microsoft Excel is probably the most powerful tool available to you. VBA is sitting on the desktops of 850 million users of Microsoft Office, and most have never figured out how to harness the power of VBA in Excel. Using VBA, you can speed the production of any task in Excel. ...