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. Accident Year Experience

    Premiums earned and losses incurred during a specific period ...
  6. Book Value Reduction

    Reducing the value at which an asset is carried on the books ...
Related Articles
  1. Investing Basics

    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 risk and return for an asset.
  2. 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.
  3. 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.
  4. Fundamental Analysis

    The History Of Information Machines

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

    The Global Electronic Stock Market

    The way trading is conducted is changing rapidly as exchanges turn toward automation.
  6. Taxes

    What is the best method of calculating depreciation for tax reporting purposes?

    Learn the best method for calculating depreciation for tax reporting purposes according to generally accepted accounting principles, or GAAP.
  7. Fundamental Analysis

    Are accounts receivable used when calculating a company's debt collateral?

    Learn how accounts receivables are recorded as assets on a balance sheet; they are used when calculating a company's total debt collateral.
  8. Fundamental Analysis

    Work In Progress (WIP)

    Work in progress, also know as WIP, is an asset on the company balance sheet. WIP is the accumulated costs of unfinished goods that are currently in the manufacturing process.
  9. Fundamental Analysis

    What is the difference between cost of equity and cost of capital?

    Read about some of the differences between a company's cost of equity and its cost of capital, two measures of its required returns on raised capital.
  10. Fundamental Analysis

    Is depreciation only used for tangible assets?

    Learn if tangible assets can be depreciated, as well as what other assets are eligible for depreciation so you can account for them accurately.

You May Also Like

Hot Definitions
  1. Multiplier Effect

    The expansion of a country's money supply that results from banks being able to lend. The size of the multiplier effect depends ...
  2. Command Economy

    A system where the government, rather than the free market, determines what goods should be produced, how much should be ...
  3. Prospectus

    A formal legal document, which is required by and filed with the Securities and Exchange Commission, that provides details ...
  4. Treasury Bond - T-Bond

    A marketable, fixed-interest U.S. government debt security with a maturity of more than 10 years. Treasury bonds make interest ...
  5. Weight Of Ice, Snow Or Sleet Insurance

    Financial protection against damage caused to property by winter weather specifically, damage caused if a roof caves in because ...
  6. Weather Insurance

    A type of protection against a financial loss that may be incurred because of rain, snow, storms, wind, fog, undesirable ...
Trading Center