What is it all about?
Visual Basic for Applications (VBA) is an implementation of Microsoft's discontinued event-driven programming language, Visual Basic 6, and its associated integrated development environment (IDE). Visual Basic for Applications (VBA) allows users additional customization beyond what is normally available in Microsoft Office products, such as Excel, Access, Word and PowerPoint.
* In VBA, users type commands into an editing module to create a macro. Macros allow users to automatically generate customized charts, reports and perform other data processing functions. Macros automate tasks and merge program functions that enable developers to build custom solutions using Visual Basic. * Visual Basic for Applications requires code to run within a host application such as Excel because it cannot run as a standalone application. * VBA for Excel is frequently used to create and maintain complex financial spreadsheet models. Visual Basic for Applications for Excel is also used to create trading, pricing and risk management models, forecast sales and earnings and generate financial ratios.