VBA is the acronym for Visual Basic for Applications. It is an integration of the Microsoft's event-driven programming language Visual Basic with Microsoft Office applications such as Microsoft Excel, Microsoft Word, Microsoft PowerPoint and many more. By running Visual Basic IDE (Integrated Development Environment) within the Microsoft Office applications, we can build customized solutions and programs to enhance the capabilities of Microsoft Office Applications.
Among the Visual Basic for applications, Microsoft Excel VBA is the most popular. There are many reasons why we should learn VBA for Microsoft Excel, among them is you can learn the fundamentals of Visual Basic programming within the MS Excel environment, without having to purchase a copy of Microsoft Visual Basic software. Another reason is by learning Excel VBA; you can build custom made functions to complement the built-in formulas and functions of Microsoft Excel. Although MS Excel has many built-in formulas and functions, they are not enough for certain complex calculations and applications. For example, it is very difficult to calculate monthly payment for a loan taken using Excel's built-in formulas, but it is relatively easier to write VBA code for such calculation.
You can write Excel VBA code in every version of Microsoft Office, including MS Office 2003, MS Office XP , MS Office 2007 and MS Office 2010. By using VBA, you can build some very powerful tools in MS Excel, including financial and scientific applications that can perform financial calculations and programs that can perform statistical analyses.