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.

BREAKING DOWN '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. Quarter - Q1, Q2, Q3, Q4

    A three-month period on a financial calendar that acts as a basis ...
  6. Surplus

    The amount of an asset or resource that exceeds the portion that ...
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. Investing

    How To Calculate Minority Interest

    Minority interest calculations require the use of minority shareholders’ percentage ownership of a subsidiary, after controlling interest is acquired.
  6. Stock Analysis

    The 5 Biggest Canadian Software Companies

    Explore information on the top revenue-generating software companies headquartered in Canada, which include some of the largest Canadian businesses overall.
  7. Entrepreneurship

    How Does AirHelp Work and Make Money?

    Learn about AirHelp's business model and monetization strategy. Discover how it can quickly submit claims for your airline delays on your behalf.
  8. Stock Analysis

    VMware: Virtualization and the Hybrid Cloud

    Read about VMware, an information technology service provide and cloud computing company, and learn about its core products and services.
  9. Economics

    Explaining Replacement Cost

    The replacement cost is the cost you’d have to pay to replace an asset with a similar asset at the present time and value.
  10. Economics

    How Does National Income Accounting Work?

    National income accounting is an economic term describing the system used by a country to gather data and determine aggregate economic activity.
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 formula for calculating weighted average cost of capital (WACC) in Excel?

    When analyzing different financing options, companies need to look at how much it will cost to fund operations. There are ... Read Full Answer >>
  3. What is the difference between a Debit Order and a Standard Order in a bank reconciliation?

    While both debit orders and standard orders represent recurring transactions that must be considered in bank reconciliations, ... Read Full Answer >>
  4. What are some examples of general and administrative expenses?

    In accounting, general and administrative expenses represent the necessary costs to maintain a company's daily operations ... Read Full Answer >>
  5. How do dividend distributions affect additional paid in capital?

    Whether a dividend distribution has any effect on additional paid-in capital depends solely on what type of dividend is issued: ... Read Full Answer >>
  6. Why can additional paid in capital never have a negative balance?

    The additional paid-in capital figure on a company's balance sheet can never be negative because companies do not pay investors ... Read Full Answer >>

You May Also Like

Hot Definitions
  1. Tiger Cub Economies

    The four Southeast Asian economies of Indonesia, Malaysia, the Philippines and Thailand. Tiger cub economy indicates that ...
  2. Gorilla

    A company that dominates an industry without having a complete monopoly. A gorilla firm has large control of the pricing ...
  3. Elephants

    Slang for large institutions that have the funds to make high volumes trades. Due to the large volumes of stock that elephants ...
  4. Widow's Exemption

    In general terms, a widow's exemption refers to the amount that can be deducted from taxable income by a widow, thereby reducing ...
  5. Wedding Warrant

    A warrant that can only be exercised if the host asset, typically a bond or preferred stock, is surrendered. Until the call ...
  6. Marlboro Friday

    A reference to Friday, April 2, 1993, when Philip Morris, the maker of Marlboro cigarettes, announced that it would be cutting ...
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!