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. Holacracy

    A holacracy is a system of governance where members of a team ...
  6. Chart Of Accounts

    A listing of each account a company owns, along with the account ...
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. 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 >>
  3. 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 >>
  4. 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 >>
  5. What is the effective interest method of amortization?

    The effective interest method is an accounting practice used for discounting a bond. This method is used for bonds sold at ... Read Full Answer >>
  6. What does an unfavorable variance indicate to management?

    In managerial accounting, an unfavorable variance is discovered when a company's management performs a comparison between ... 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. Inbound Cash Flow

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

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

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

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

    The currency or legal tender issued by a nation's central bank or monetary authority. The national currency of a nation is ...
  6. Treasury Yield

    The return on investment, expressed as a percentage, on the debt obligations of the U.S. government. Treasuries are considered ...
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!