We’re more familiar with Excel’s built-in formula, such as AVERAGE, SUM, IF, and etc, but not many of us know how to utilize its built-in language VBA (Visual Basic for Application) which is known as “Macros”. This kind of Excel files is saved as ” .xlsm” format.
If you want to use VBA in Excel, you need to enable the tab of “Developer” first in the ribbon. Here is the path: right-click File -> Customize Ribbon -> check Developer tab. Then, you can set up your layout. Under the “Developer” interface, you can write VBA codes to different events. Getting started with VBA in Excel 2010 by going through this tutorial.