Visual Basic For Applications - VBA

AAA

DEFINITION of 'Visual Basic For Applications - VBA'

A computer programming language developed by Microsoft which allows the development of user-defined functions and the automation of certain processes and calculations. Visual Basic For Applications is a standard feature of Microsoft Office products.

INVESTOPEDIA EXPLAINS 'Visual Basic For Applications - VBA'

Visual Basic For Applications allows user a level of customization beyond what is typically available in Microsoft Office products, such as Excel, Word and Power Point. A user types commands into an editing module to create a macro. Macros can allow the user to automatically generate customized reports, charts and perform other data processing functions. Within the finance industry, VBA for Excel is commonly used to develop and maintain complex financial spreadsheet models.

RELATED TERMS
  1. Bleeding Edge Technology

    Technology that is acquired almost immediately after its release, ...
  2. Gantt Chart

    A Gantt chart is a visual representation of a project schedule. ...
  3. Proprietary Technology

    A process, tool, system or similar item that is the property ...
  4. Chief Information Officer - CIO

    A company executive who is responsible for the management, implementation ...
  5. Wealth Management

    A high-level professional service that combines financial/investment ...
  6. Holacracy

    A holacracy is a system of governance where members of a team ...
RELATED FAQS
  1. How do you the calculate Sharpe ratio in Excel?

    The Sharpe ratio helps investors evaluate the relationship between risk and return for an asset. Since it was introduced ... Read Full Answer >>
  2. What is the difference between a write-off and a writedown?

    In terms of accounting, a write-down is performed to reduce the value of an asset to offset a loss or expense. A write-down ... Read Full Answer >>
  3. What are some good online resources for me to learn about Generally Accepted Accounting ...

    The two definitive authorities on developing and interpreting the U.S. generally accepted accounting principles, or GAAP, ... Read Full Answer >>
  4. How do you calculate shareholder equity?

    Shareholders' equity is listed on a company's balance sheet and measures its net worth. A company's shareholders' equity ... Read Full Answer >>
  5. What is the difference between earnings and profit?

    Earnings, specifically retained earnings, and profit are often used as synonyms in corporate finance, although they are different ... Read Full Answer >>
  6. How is minimum transfer price calculated?

    A company that transfers goods between multiple divisions needs to establish a transfer price so that each division can track ... Read Full Answer >>
Related Articles
  1. Forex Education

    Forex Automation Software For Hands-Free Trading

    Automated forex trading software scans the market for favorable trades based on your input. Find out more about this valuable forex tool.
  2. Professionals

    Microsoft Excel Features For The Financially Literate

    Here are some of Excel's functions and features that a financial professional can use to make his or her job more efficient.
  3. Fundamental Analysis

    The History Of Information Machines

    Discover how technology changed the way we exchange information when trading.
  4. Trading Systems & Software

    The Global Electronic Stock Market

    The way trading is conducted is changing rapidly as exchanges turn toward automation.
  5. Fundamental Analysis

    Zappos.com & Holacracy, Will It Work?

    Zappos amounts to the most expansive corporate implementation of Holacracy. Why did they do it?
  6. Economics

    Calculating Net Realizable Value

    An asset’s net realizable value is the amount a company should expect to receive once it sells or disposes of that asset, minus costs from its disposal.
  7. Investing Basics

    Calculating Unlevered Free Cash Flow

    Unlevered free cash flow (UFCF) is the free cash flow of a business before interest payments.
  8. Taxes

    Understanding Write-Offs

    Write-off has different meanings depending on the context in which it is used, but generally refers to a reduction in value due to expense or loss.
  9. Economics

    What are Capital Goods?

    Capital goods are assets with a useful life of more than one year that are used for the production of income.
  10. Economics

    Understanding Capital Assets

    A capital asset is one that a company plans on owning for more than one year, and uses in the production of revenue.

You May Also Like

Hot Definitions
  1. Radner Equilibrium

    A theory suggesting that if economic decision makers have unlimited computational capacity for choice among strategies, then ...
  2. Inbound Cash Flow

    Any currency that a company or individual receives through conducting a transaction with another party. Inbound cash flow ...
  3. Social Security

    A United States federal program of social insurance and benefits developed in 1935. The Social Security program's benefits ...
  4. American Dream

    The belief that anyone, regardless of where they were born or what class they were born into, can attain their own version ...
  5. Multicurrency Note Facility

    A credit facility that finances short- to medium-term Euro notes. Multicurrency note facilities are denominated in many currencies. ...
  6. National Currency

    The currency or legal tender issued by a nation's central bank or monetary authority. The national currency of a nation is ...
Trading Center
×

You are using adblocking software

Want access to all of Investopedia? Add us to your “whitelist”
so you'll never miss a feature!