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. Operating Cost

    Expenses associated with the maintenance and administration of ...
  6. Trade Credit

    An agreement where a customer can purchase goods on account (without ...
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. Economics

    Explaining Enterprise Resource Planning

    Enterprise resource planning (ERP) is management software that integrates a business’ essential departments.
  6. Investing Basics

    What's Current Portion of Long-Term Debt?

    The current portion of long-term debt is the part of a company’s long-term debt that must be repaid within the next year.
  7. Economics

    Explaining Cost Control

    For a business, cost control entails managing and reducing expenses.
  8. Economics

    Explaining Accounting Conservatism

    Accounting conservatism is a principal that requires accounting rules be applied with high degrees of verification.
  9. Term

    What are Non-GAAP Earnings?

    Non-GAAP earnings are a company’s earnings that are not reported according to Generally Accepted Accounting Principles.
  10. Stock Analysis

    Fortinet: A Great Play on Cybersecurity

    Discover how a healthy product mix, large-business deal growth and the boom of the cybersecurity industry are all driving Fortinet profits.
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 dividends affect the balance sheet?

    Dividends paid in cash affect a company's balance sheet by decreasing the company's cash account on the asset side and decreasing ... Read Full Answer >>
  3. Are dividends considered an expense?

    Cash or stock dividends distributed to shareholders are not considered an expense on a company's income statement. Stock ... Read Full Answer >>
  4. Do dividends go on the balance sheet?

    The only account recorded on the balance sheet, when dividends are declared and before they are paid out to a company's shareholders, ... Read Full Answer >>
  5. 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 >>
  6. 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 >>

You May Also Like

Hot Definitions
  1. Recession

    A significant decline in activity across the economy, lasting longer than a few months. It is visible in industrial production, ...
  2. Bubble Theory

    A school of thought that believes that the prices of assets can temporarily rise far above their true values and that these ...
  3. Stock Market Crash

    A rapid and often unanticipated drop in stock prices. A stock market crash can be the result of major catastrophic events, ...
  4. Financial Crisis

    A situation in which the value of financial institutions or assets drops rapidly. A financial crisis is often associated ...
  5. Election Period

    The period of time during which an investor who owns an extendable or retractable bond must indicate to the issuer whether ...
  6. Shanghai Stock Exchange

    The largest stock exchange in mainland China, the Shanghai Stock Exchange is a nonprofit organization run by the China Securities ...
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!