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. Killer Application

    A killer application, or "killer app" is a software program with ...
  2. Baby Bills

    Baby Bills is the name given to the companies that would have ...
  3. Credit Application

    A credit application is a request for an extension of credit. ...
  4. What is

    Augmented reality is the modification of a real-life environment ...
  5. SEC Form T-3

    An application for the qualification of an indenture that must ...
  6. Borderline Risk (Insurance)

    Borderline risk refers to an insurance policy applicant that ...
Related Articles
  1. Tech

    Advisor Tools: To ‘Excel’ or Not Excel?

    Microsoft Excel has been a staple of the financial services industry for decades but specialized advisor software solutions have sprung up in recent years.
  2. Small Business

    The Importance Of Office To Microsoft

    The mobile and cloud revolution were expected to sound the death knell for the Office suite of products, but a new era is beginning for Microsoft Office.
  3. 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.
  4. 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.
  5. 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.
  6. Investing

    Microsoft's Cloud, LinkedIn Deal Dominate 2016

    Microsoft's growth in cloud services and its emergence into a threat to Amazon was one of 2016's biggest surprises
  7. Investing

    Microsoft: Users Locked Out of Accounts Tuesday

    Microsoft was hit with an outage Tuesday morning that knocked out a slew of its online services.
  8. Investing

    Top Mutual Fund Holders of Microsoft (MSFT)

    Discover the top four largest mutual fund owners of Microsoft shares, and determine how their portfolios benefit from these holdings.
  9. 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.
RELATED FAQS
  1. Who are Microsoft's (MSFT) main competitors?

    Are you investing in Microsoft? Learn the main competitors of technology giant Microsoft and the stiff competition facing ... Read Answer >>
  2. What are some common functions of business intelligence technologies?

    Understand the common functions of business intelligence technologies, and learn how business intelligence is used to increase ... Read Answer >>
  3. 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 >>
  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. How do I calculate production costs in Excel?

    Find out about ways to use Excel to simplify production cost calculation and some sources of good templates and tips for ... Read Answer >>
Hot Definitions
  1. Portfolio

    A portfolio is a grouping of financial assets such as stocks, bonds and cash equivalents, also their mutual, exchange-traded ...
  2. Gross Profit

    Gross profit is the profit a company makes after deducting the costs of making and selling its products, or the costs of ...
  3. Diversification

    Diversification is the strategy of investing in a variety of securities in order to lower the risk involved with putting ...
  4. Intrinsic Value

    Intrinsic value is the perceived or calculated value of a company, including tangible and intangible factors, and may differ ...
  5. Current Assets

    Current assets is a balance sheet item that represents the value of all assets that can reasonably expected to be converted ...
  6. Volatility

    Volatility measures how much the price of a security, derivative, or index fluctuates.
Trading Center