DEFINITION of 'Visual Basic For Applications - VBA'

Visual Basic is a computer programming language that allows for the creation of user-defined functions and the automation of specific computer processes and calculations. Users do not have to buy a copy of Visual Basic professional because Visual Basic for Applications is a standard feature of Microsoft Office products. 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.

BREAKING DOWN 'Visual Basic For Applications - VBA'

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 stand-alone application.

In the finance industry, 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.

It is user-intuitive, which allows those with little or no computer programming knowledge to learn VBA. It is an event-driven programming language specifically designed to customize applications that contain the Visual Basic for Applications application-programming interface (API). VBA is used to control the functionality of Microsoft Excel and any other Microsoft Office application.

The program can be used to keep lists of customers’ names or other data, create invoices and forms, develop charts, analyze scientific data, and for budgeting and forecasting. It can also control several features of a host application such as Excel, including manipulating user interface features, such as toolbars and menus and working with dialog boxes or customized user forms.

How It Is Used

In addition to Microsoft, numerous companies have used VBA to add the programming capabilities to their own applications. Visual Basic for Applications is also implemented in applications published by other companies including AutoCAD, ArcGIS, CATIA, CorelDraw and SolidWorks. VBA enables an application, such as Excel, to run a program internally and provide a customized version of Excel for a specific purpose, such as how long it takes to earn $1 million in an investment portfolio based on a specific interest rate and the number of years until retirement.

Support

On July 1, 2007, Microsoft stopped offering VBA distribution licenses to new customers. Microsoft created Visual Studio, which contained a separate scripting tool called Visual Studio for Applications (VSA) that supported Visual Basic .NET. One of VSA’s main features was that the interfaces were available through active scripting, allowing .NET-unaware applications to be scripted via .NET languages. However, VSA was retired in the 2.0 version of the .NET Framework, leaving no alternative for applications desiring active scripting support. Microsoft ended Visual Basic for Applications support for Microsoft Office 2008 for Mac computers. However, VBA support was restored in Microsoft Office for Mac 2011.

RELATED TERMS
  1. Mortgage Application

    A document submitted to a lender to borrow money to purchase ...
  2. Loan Application Fee

    A loan application fee is a fee charged to a potential borrower ...
  3. Borderline Risk (Insurance)

    Borderline risk refers to an insurance policy applicant that ...
  4. Automated Underwriting

    Automated underwriting is a technology driven underwriting process ...
  5. Resume

    A resume is a formal document that lists a job applicant's work ...
  6. Weekly Mortgage Applications Survey

    The Weekly Mortgage Applications Survey is a weekly assessment ...
Related Articles
  1. Small Business

    The Importance of Excel in Business

    Microsoft Excel is an indispensable tool for any business.
  2. Investing

    Microsoft Launches Office 365 in 10 New Countries (MSFT)

    Microsoft Office 365 will now be available in 10 additional countries. This means Office 365 is now available in 150 markets and 44 languages.
  3. Investing

    The Real Secret To Microsoft's Success

    Microsoft is no longer in the raw experimentation stage common to young and growing companies. Rather, its main goal is to create profitability streams, then maintain and expand them.
  4. Investing

    Microsoft's New Reporting Structure: A Closer Look (MSFT)

    Learn about the changes being made to the reporting structure of Microsoft's books and how they will affect the way investors read the company's financials.
  5. Investing

    Must-Have Software For The Home Office

    If you have a home business, these pieces of software can be extremely helpful to you.
  6. Retirement

    10 Best Smartphone Apps For Seniors

    Whether it's for health, news or personal finance, these apps can be useful for seniors. Best of all, they are free.
  7. Investing

    Microsoft Word Target of Zero-Day Malware Attack

    Microsoft's Word has a new vulnerability that can enable hackers to secretly install malware.
  8. Investing

    Guide To Excel For Finance

    Formulas, functions and features you need to know when using Excel for financial analysis.
  9. Small Business

    What Facebook Owns That Other Social Media Do Not (FB)

    Examine Facebook's competitive advantage to understand how the network effect and application suite set it apart from other social media platforms.
  10. Trading

    Microsoft Reports Within a Zone of Risky Levels

    Microsoft reports earnings with an elevated P/E ratio of 58.40, a small dividend yield of just 1.60% and an overbought weekly chart.
RELATED FAQS
  1. How do I perform a financial analysis using Excel?

    Find out how to perform financial analysis through Microsoft Excel, a widely used business management software among finance ... Read Answer >>
  2. Why do options with the same underlying stock and strike prices trade for different ...

    You would think that two options with the same underlying stock and strike prices would trade at the same price, but interestingly ... Read Answer >>
  3. What are some of the better types of financial analysis software?

    Discover what features make for good financial analysis software, some popular options and why analysts need to pick the ... Read Answer >>
  4. Is there an easy way to do financial forecasting in Excel?

    Find out how to use Excel to conduct financial forecasting. Learn how to build a complex financial model, and discover functions ... Read Answer >>
  5. Can Foreigners Open Savings Accounts in the US?

    Find out what it takes for a foreign individual to open a savings accounts in the US especially in the age of heightened ... Read Answer >>
Trading Center