Get to know your VBE (Visual Basic Editor)

VBE or Visual Basic Editor is an application attached to Microsoft Office like Excel, Word and Power point. This is where we kept our coding for each macro recorded. That why before we get started to write your own macro you must be able to use this application. Actually this application same as like any other office application, layout, button, function and etc except this application is design to suit the purpose as a programming tools. As a programming tools of course there must have form (interface design), module (code storage), debugging and etc. To open this as usual :

1. Open your new excel file
   
2. Under Tools menu Click on Macro then Macros
   
3. Click on Visual Basic Editor

Click here to learn how to open visual basic editor

Therefore you must learn how to use this application before get started and below items you must know first as well as others:

1. Project Explorer
   If you open blank excel and open your VBE at your left pane you will see Project – VBAProject, Under this you will be able to see folder list VBAProject(Book1) follow by Microsoft Excel Objects.
   
   
   Before recording no modules under project explorer.
   
   
2. Modules
   This is where your coding to be kept after recording or to write your on your own.
   
   
   After recording modules appeared.
   Note : Click on modules folder if you unable to see module1
   

Just play around with VBE then later you will get familiar because others function almost similar with others office application.
Good Luck.

Click here if you have any new project! Let us create for u for free.
Thanks