Excel VBA: A Beginner’s Guide to Visual Basic for Applications (Macros, Programming, Functions, Statements) (Jordan Koma’s Excel Books Book 2)

Visual Basic for Applications (VBA) is standard language that used in most of Microsoft application within the Microsoft Office suite such as Microsoft Word, Excel, Access and PowerPoint, although Access, Excel and Word are the most commonly used out of them.

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