Before starting with Excel Macro, we need to know, how to open Visual Basic Editor where one should write the code for Excel Macro. To go to Visual Basic Editor is different in different version of MS Excel.
Excel 2003 | Excel 2007 / 2010

How to Open VBE in Excel 2003


1. Go to Tools -> Macro -> Visual Basic Editor (Short Key: ALT + F11)

Excel Macro Tutorial : VB Editor 2003

2. Visual Basic Editor will open in a new Window as shown below

Excel Macro Tutorial : VB Editor 2003 - 2

OR

1. Right click on any of the Sheet Name
2. Click on View Code

Excel Macro Tutorial : View Code

Note: The left window with the sheet names in it is called the Project Explorer. If Project Explorer is not visible in left side, click on View and then Project Explorer. Most probably the Project Explorer will already appear as a column on the left side of the screen. If not, execute the following three steps to achieve this.

How to Open VBE in Excel 2007 / 2010

1. Click on Visual Basic Editor or press ALT + F11

Excel Macro Tutorial : VB Editor-2007-1

2. Visual Basic Editor will open in a new Window as shown below

Excel Macro Tutorial : VB Editor-2007- 2

OR

1. Right click on any of the Sheet Name
2. Click on View Code

Excel Macro Tutorial : View Code

Note: The left window with the sheet names in it is called the Project Explorer. If Project Explorer is not visible in left side, click on View and then Project Explorer. Most probably the Project Explorer will already appear as a column on the left side of the screen. If not, execute the following three steps to achieve this.
 
To Check out more Excel Macro Tutorials, visit Excel Macro Tutorial

cover3d_0-89071700_1484285537__1_

Join over 10, 000+ Excel VBA Enthusiasts & get this FREE e-Book Now!