Opening the VBA Editor

The following steps will show you how to activate the Developer menu, which you will need to create your VBA code:

1. Fire up Excel 2013 and create a new spreadsheet. Go to the FILE menu and select the Options button, as shown in the following screenshot:

   

2. In the Excel Options dialog box, select the Customize Ribbon option.

   

3. On the right-hand side of the Excel Options dialog box, check the Developer checkbox, as shown in the following screenshot. Then, click on the OK button to apply the changes.

   

   You will now see that the DEVELOPER menu has been added to the ribbon.

   

4. Select the DEVELOPER tab and click on the Visual Basic button.

   

   Tip

   You do not need to activate the DEVELOPER tab. You simply need to press the ALT + F11 keys on your keyboard to open the VBA Editor.

Excel will open a new window, which is named Microsoft Visual Basic for Applications – Book1, and will have a project pane similar to the following screenshot:

Congratulations! You are now ready to begin coding and ready...