DEFINITION of 'Visual Basic For Applications - VBA'

Visual Basic is a computer programming language allows 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 standalone 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 users 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). It is used to control the functionality of Microsoft Excel and any other Microsoft Office application.

It 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 be used to 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 that 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. Enterprise Application Integration

    The translation of data and other commands from one application ...
  2. In-App Purchasing

    The purchase of goods and services from an application on a mobile ...
  3. Mortgage Application

    A document submitted by one or more individuals applying to borrow ...
  4. Loan Application Fee

    A fee charged to process an application for a loan, such as a ...
  5. Correction Notice

    A notice indicating that a process or application contains errors ...
  6. Baby Bills

    A hypothetical nickname for the smaller companies that would ...
Related Articles
  1. Financial Advisor

    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. Small Business

    The Importance of Excel in Business

    Microsoft Excel is an indispensable tool for any business.
  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

    An Overview of Businesses Owned by Microsoft (MSFT)

    Microsoft is much more than a software company. Here are five businesses owned by the multi-billion dollar conglomerate.
  6. Small Business

    What Did Microsoft See in LinkedIn? (MSFT, LNKD)

    Explore reasons behind Microsoft's $26.2 billion acquisition of LinkedIn, including the savings resulting from borrowing the funds rather than spending cash.
  7. Financial Advisor

    Trendlines

    Trendlines are a visual representation of support and resistance in any time frame.
  8. Investing

    Behind Microsoft's 127.4% Rise in 10 Years (MSFT)

    The most influential factors behind Microsoft's historical stock price price include tech valuations and the company's evolving product portfolio.
  9. Small Business

    Indian Tech Startups Eye The Future With Visual Recognition

    Using visual recognition technology, Indian tech companies are hoping to help online merchants close more sales from consumers who are on mobile devices.
  10. 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.
RELATED FAQS
  1. Why was Microsoft subject to antitrust charges in 1998?

    On May 18, 1998, the Department of Justice filed antitrust charges against Microsoft (Nasdaq:MSFT ). The charges were brought ... Read Answer >>
  2. Who are Microsoft's (MSFT) main competitors?

    Discover the main competitors of technology giant Microsoft and the stiff competition facing this industry leader. Find out ... Read Answer >>
  3. How do you the calculate Sharpe ratio in Excel?

    Learn how to use Microsoft Excel to calculate the Sharpe ratio, an investing tool useful for assessing the relationship between ... Read Answer >>
  4. How do I perform a financial analysis using Excel?

    Find out how to perform financial analysis through Microsoft Excel, which is probably the most widely used software among ... Read Answer >>
  5. What's an easy way of calculating gross sales in Excel?

    Use Excel to calculate gross sales, display sales data, and establish a template that allows for extensive sales calculations ... Read Answer >>
  6. How do I apply for Social Security retirement benefits?

    Understand the process of applying for Social Security benefits, the kinds of information and documentation you need, and ... Read Answer >>
Hot Definitions
  1. Cover Letter

    A written document submitted with a job application explaining the applicant's credentials and interest in the open position. ...
  2. 403(b) Plan

    A retirement plan for certain employees of public schools, tax-exempt organizations and certain ministers. Generally, retirement ...
  3. Master Of Business Administration - MBA

    A graduate degree achieved at a university or college that provides theoretical and practical training to help graduates ...
  4. Liquidity Event

    An event that allows initial investors in a company to cash out some or all of their ownership shares and is considered an ...
  5. Job Market

    A market in which employers search for employees and employees search for jobs. The job market is not a physical place as ...
  6. Yuppie

    Yuppie is a slang term denoting the market segment of young urban professionals. A yuppie is often characterized by youth, ...
Trading Center