To use VBA in Excel you need Developer Tab in the Ribbon. In this tutorial you will learn how to enable developer tab in Excel.
How to enable Developer tab in Excel?
Click File tab.
Go to Options.
Click Customize Ribbon.
Tick Developer check box.
Now you can see Developer tab at the Ribbon in Excel.