In general, Macro is a program written or recorded in Visual Basic programming language. In Microsoft Excel writing, editing or developing happens under Visual Basic programming language in VBA Environment.
What is Macro?
Macro is nothing but a shortcut switch of some difficult task at once. It can be define as, a collection of commands which you can start by a single click. It is a programming language. It uses Visual Basic programming languages.
To learn Macro Writing you need to learn Visual Basic programming which can help you to write your macros easily. On the other hand, if you do not have any idea about Visual Basic programming language, then you need to write your own macros with the help of Macro Recording.
What is VBA?
Visual Basic is a programming language built into Microsoft Excel form the Microsoft Excel 5.0 version. VB is added with Microsoft Excel for adding extra features. All macros are written under VBA Environment. If you know VB then you can handle many things and can built a good relation to others Microsoft Products.
There is no chance to remove this feature (VBA) from Microsoft Excel. If it has done, then billions of macros written in VBA around the world will stop working. So, without fear, all Microsoft Excel users should learn it.
Why VBA is important?
(1) Customize and extend the capabilities of MS Excel
(2) Make the work easy, quick and automate
(3) Reduce errors
(4) It works very fast
(5) For large data it is very easy to handle
(6) It allows to create custom form which is user defined
What are the areas of learning Excel VBA?
(a) VBA Environment:
The graphical user interface with 4 different windows are involved in VBA Environment. These are:
(1) Project Window
(2) Properties Window
(3) Immediate Window
(4) Code Window
To view these windows, press ALT+F11 in your MS Excel sheet. After pressing you will see VBA Environment. To see the complete windows Click on Insert Module, and then Double Click on Module1 from project window. Then the above 4 windows will display like below:
(b) Procurement:
Procurement is a group of structured code writing. It is two types:
1) Sub procurement: This is a set of instruction what the computer will do.
2) Function: This is a single instruction what the computer will do and returns a result.
(c) Modules:
All of your VBA code needs to write in this window. Even while a macro recorded it stores here. All kinds of code related task like editing codes, inserting codes, writing codes, recording codes have done here.
(d) Objects:
Objects are those which you can see in MS Excel. Some of these are:
(1) Worksheets
(2) Cells
(3) Mouse Pointer
(4) Cell Range
(5) Pivot Table
(6) Charts
(7) Auto Shapes etc.
Objects has 2 main characteristics:
1) Properties Examples:
The cell color, cell border, cell alignment are properties. It is the attributes of an object. That means if you ask on which you may apply the command then the answer will be an Object Properties. Such as, Worksheets("Sheet1") is a Object Properties.
2) Methods Examples:
It is a set of instructions where instructed the cell color to blue, cell border 1.5 pt, cell alignment center etc. Here, Cell Color is Properties but which color, Blue is a Method.
Image 1: Visual Basic for Applications
What is Macro?
Macro is nothing but a shortcut switch of some difficult task at once. It can be define as, a collection of commands which you can start by a single click. It is a programming language. It uses Visual Basic programming languages.
To learn Macro Writing you need to learn Visual Basic programming which can help you to write your macros easily. On the other hand, if you do not have any idea about Visual Basic programming language, then you need to write your own macros with the help of Macro Recording.
What is VBA?
Visual Basic is a programming language built into Microsoft Excel form the Microsoft Excel 5.0 version. VB is added with Microsoft Excel for adding extra features. All macros are written under VBA Environment. If you know VB then you can handle many things and can built a good relation to others Microsoft Products.
There is no chance to remove this feature (VBA) from Microsoft Excel. If it has done, then billions of macros written in VBA around the world will stop working. So, without fear, all Microsoft Excel users should learn it.
Why VBA is important?
(1) Customize and extend the capabilities of MS Excel
(2) Make the work easy, quick and automate
(3) Reduce errors
(4) It works very fast
(5) For large data it is very easy to handle
(6) It allows to create custom form which is user defined
What are the areas of learning Excel VBA?
(a) VBA Environment:
The graphical user interface with 4 different windows are involved in VBA Environment. These are:
(1) Project Window
(2) Properties Window
(3) Immediate Window
(4) Code Window
To view these windows, press ALT+F11 in your MS Excel sheet. After pressing you will see VBA Environment. To see the complete windows Click on Insert Module, and then Double Click on Module1 from project window. Then the above 4 windows will display like below:
Image 2: Different windows in VBA Environment
(b) Procurement:
Procurement is a group of structured code writing. It is two types:
1) Sub procurement: This is a set of instruction what the computer will do.
2) Function: This is a single instruction what the computer will do and returns a result.
(c) Modules:
All of your VBA code needs to write in this window. Even while a macro recorded it stores here. All kinds of code related task like editing codes, inserting codes, writing codes, recording codes have done here.
(d) Objects:
Objects are those which you can see in MS Excel. Some of these are:
(1) Worksheets
(2) Cells
(3) Mouse Pointer
(4) Cell Range
(5) Pivot Table
(6) Charts
(7) Auto Shapes etc.
Objects has 2 main characteristics:
Image 3: VBA Object Types
1) Properties Examples:
The cell color, cell border, cell alignment are properties. It is the attributes of an object. That means if you ask on which you may apply the command then the answer will be an Object Properties. Such as, Worksheets("Sheet1") is a Object Properties.
2) Methods Examples:
It is a set of instructions where instructed the cell color to blue, cell border 1.5 pt, cell alignment center etc. Here, Cell Color is Properties but which color, Blue is a Method.