VBA helps user to create customized solutions and applications to enhance the capabilities of the above mentioned applications. The biggest advantage VBA has is that we do not need to have VBA installed on our PC, but are able to program within Microsoft Office applications.
Using VBA a user can create macros or small programs that can perform tasks within many of the Microsoft applications, you are able to automate thousands of different tasks such as:
• Keeping a list of things, such as student’s grade, customer names, addresses
• Forecasting cash flow and budgeting
• Analyzing large data sets
• Formatting invoices
• Developing graphs
The list goes on and on, but you get the idea that the possibilities are endless with VBA