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. Chief Information Officer - CIO

    A company executive who is responsible for the management, implementation ...
  4. Proprietary Technology

    A process, tool, system or similar item that is the property ...
  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. 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. Trading Systems & Software

    The Global Electronic Stock Market

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

    The History Of Information Machines

    Discover how technology changed the way we exchange information when trading.
  5. Budgeting

    Find The Best Personal Finance Software

    Should you pay for personal finance software or get it free? The best program for you depends on your needs and how private you want to be about money.
  6. This website offers free tools and helpful videos for those needing to keep good track of their finances
    Savings

    Mint.com: Top Free Tools To Track Your Money

    This website offers free tools and helpful videos for those needing to keep good track of their finances
  7. Investing

    Who's The Better Financial New Source: The Motley Fool or Seeking Alpha

    This is a comparison of two of the most popular investment research sites: The Motley Fool and Seeking Alpha.
  8. Fundamental Analysis

    What is the difference between a capital gearing ratio and a net gearing ratio?

    Understand the definition of gearing in the finance industry, the difference between net gearing and capital gearing ratios and how they are interpreted.
  9. Investing Basics

    What is the difference between the gearing ratio and the debt-to-equity ratio?

    Dive deeper into gearing ratios: what are they, how are they used and why the debt to equity ratio is one of the most popular analytical gearing tools.
  10. Fundamental Analysis

    What is the difference between interest coverage ratio and DSCR?

    Understand the basics of the interest coverage ratio and the debt-service coverage ratio, including calculations and how each type reflects financial stability.

You May Also Like

Hot Definitions
  1. Multinational Corporation - MNC

    A corporation that has its facilities and other assets in at least one country other than its home country. Such companies ...
  2. SWOT Analysis

    A tool that identifies the strengths, weaknesses, opportunities and threats of an organization. Specifically, SWOT is a basic, ...
  3. Simple Interest

    A quick method of calculating the interest charge on a loan. Simple interest is determined by multiplying the interest rate ...
  4. Special Administrative Region - SAR

    Unique geographical areas with a high degree of autonomy set up by the People's Republic of China. The Special Administrative ...
  5. Annual Percentage Rate - APR

    The annual rate that is charged for borrowing (or made by investing), expressed as a single percentage number that represents ...
  6. Free Carrier - FCA

    A trade term requiring the seller to deliver goods to a named airport, terminal, or other place where the carrier operates. ...
Trading Center