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. Wealth Management

    A high-level professional service that combines financial/investment ...
  6. Holacracy

    A holacracy is a system of governance where members of a team ...
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 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 >>
  3. 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 >>
  4. 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 >>
  5. 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 >>
  6. When does the fixed charge coverage ratio suggest that a company should stop borrowing ...

    Since the fixed charge coverage ratio indicates the number of times a company is capable of making its fixed charge payments ... 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. Economics

    What's an Allowance for Doubtful Accounts?

    The allowance for doubtful accounts represents the percentage of the accounts receivable the company expects to write-off as uncollectible.
  6. Fundamental Analysis

    Understanding Activity Ratios

    Activity ratios measure how effectively a business uses its assets.
  7. Investing Basics

    What is Accrued Income?

    In a mutual fund, accrued income is earnings that have accumulated over the year, but have not yet been paid out to shareholders.
  8. Fundamental Analysis

    Explaining the Common Size Income Statement

    A common size income statement expresses each account as a percentage of net sales.
  9. Professionals

    What Does an Auditor Do?

    An auditor ensures that organizations maintain accurate and honest financial records.
  10. Fundamental Analysis

    Calculating the Net Debt to EBITDA Ratio

    Financial analysts typically use the net debt to EBITDA ratio to determine a company’s ability to pay its debt.

You May Also Like

Hot Definitions
  1. Bogey

    A buzzword that refers to a benchmark used to evaluate a fund's performance. The benchmark is an index that reflects the ...
  2. Xetra

    An all-electronic trading system based in Frankfurt, Germany. Launched in 1997 and operated by the Deutsche Börse, the Xetra ...
  3. Nuncupative Will

    A verbal will that must have two witnesses and can only deal with the distribution of personal property. A nuncupative will ...
  4. OsMA

    An abbreviation for Oscillator - Moving Average. OsMA is used in technical analysis to represent the variance between an ...
  5. Investopedia

    One of the best-known sources of financial information on the internet. Investopedia is a resource for investors, consumers ...
  6. Unfair Claims Practice

    The improper avoidance of a claim by an insurer or an attempt to reduce the size of the claim. By engaging in unfair claims ...
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!