Home > Articles > Home & Office Computing > Microsoft Applications

Unleash the Power of Excel with VBA

  • ⎙ Print
  • + Share This
This chapter introduces the features and functions of Excel and VBA, showing you how to create and run macros and understand their inner workings using the VBA editor.
This chapter is from the book

This chapter is from the book

VBA and Macros: Microsoft Excel 2010VBA and Macros: Microsoft Excel 2010

Learn More Buy

This chapter is from the book

This chapter is from the book

VBA and Macros: Microsoft Excel 2010VBA and Macros: Microsoft Excel 2010

Learn More Buy

IN THIS CHAPTER

  • The Power of Excel 7
  • Barriers to Entry 7
  • Knowing Your Tools: The Developer Tab 9
  • Macro Security 10
  • Overview of Recording, Storing, and Running a Macro 12
  • Running a Macro 14
  • Using New File Types in Excel 2010 18
  • Understanding the VB Editor 19
  • Understanding Shortcomings of the Macro Recorder 21

The Power of Excel

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 500 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. If you regularly use Excel to produce a series of monthly charts, you can have VBA do the same task for you in a matter of seconds.

  • + Share This
  • 🔖 Save To Your Account