VBA full form is Visual Basic for Applications. It is the programming language of Excel and other Office programs. Points to be learned for working with VBA/Macros are as follow.

1. For creating a Macro in Excel VBA can be use to automate tasks by writing so called macros.

2. MsgBox: The MsgBox is a dialog box in VBA which is use to inform the users of your program any information or warnings.

3. Workbook and Worksheet are Objects. Learning more about the Workbook and Worksheet object in VBA is important.

4. Range Object which is the representation of a cell (or cells) on your worksheet, is the most important object of VBA coding.

5. Variables teaches you how to declare, initialize and display a variable in VBA.

6. Use the If Then statement in VBA to execute code lines if a specific condition is met.

7. Loops is one of the most powerful programming techniques. A loop in VBA enables you to loop through a range of cells with just a few codes lines.

8. Macro Errors: This teaches you how to deal with macro errors in Excel.

9. String Manipulation will find the most important functions to manipulate strings in VBA.

10. Date and Time: Learn how to work with dates and times in VBA.

11. Events are actions performed by users which trigger VBA to execute code.

12. An array is a group of variables. In VBA, you can refer to a specific variable (element) of an array by using the array name and the index number.

13. Function and Sub in VBA, a function can return a value while a sub cannot.

14. Application Object is mother of all objects is Excel itself. We call it the Application object. The application object gives access to a lot of Excel related options.

15. Learn how to create ActiveX controls such as command buttons, text boxes, list boxes etc.

16. Learn how to create an VBA Userform.

Want to learn much more about VBA programming in Excel and with other applications? Stay tuned we will give you step by step guide to work with it.