VBA MODULE 2
Activate Developer Tab
First we will need to enable Developer tab in our excel workbook to start with the VBA coding. Below are the steps to get the Developer tab:-
1. Go to the top of the workbook where you see the menu and right click anywhere in the menu area and you will get the option to customize it so select it.
2. Now look for the Developer tab. Check the menu at the left. It might be in the Popular menu (if you are using Excel 2007) or in the Customize menu as per the excel version you are using.
3. Put a tick mark in the checkbox next to Developer.
4.. Click ok to save the change and go back to your workbook. Now you can see Developer tab in the top menu. When you click on the tab, it displays the information that will help us in VBA programming going further