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. Mobile First Strategy

    Mobile first strategy is trend in website development where designing ...
  6. Capital Expenditure (CAPEX)

    Funds used by a company to acquire or upgrade physical assets ...
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 >>
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

    What's a Run Rate?

    Run rate is a term used to denote annualized earnings extrapolated from a shorter time frame. Management uses the run rate to estimate future revenues.
  6. Professionals

    Financial Accounting

    Financial accounting is the process of gathering, recording, summarizing and reporting financial data relating to a business. The ultimate goal is to accurately report the financial picture and ...
  7. Investing

    What are Direct Costs?

    Direct costs for finished goods refer to the items and services directly used in production. Other costs such as rent and insurance for the production site are indirect costs. These costs may ...
  8. Investing

    What is Contingent Liability?

    A contingent liability is an amount that might have to be paid in the future, but there are still unresolved matters that make it only a possibility. Lawsuits and the threat of lawsuits are the ...
  9. Investing

    What's Accrued Interest?

    Accrued interest has two meanings. In accounting, it is interest that has been earned, but the time for payment has not yet occurred.
  10. Investing

    What is Absorption Costing?

    Absorption costing is an accounting method primarily used in manufacturing. In absorption costing, the cost of a manufactured product includes the direct costs plus an apportioned share of the ...

You May Also Like

Hot Definitions
  1. Interest Rate Risk

    The risk that an investment's value will change due to a change in the absolute level of interest rates, in the spread between ...
  2. Income Effect

    In the context of economic theory, the income effect is the change in an individual's or economy's income and how that change ...
  3. Price-To-Sales Ratio - PSR

    A valuation ratio that compares a company’s stock price to its revenues. The price-to-sales ratio is an indicator of the ...
  4. Hurdle Rate

    The minimum rate of return on a project or investment required by a manager or investor. In order to compensate for risk, ...
  5. Market Value

    The price an asset would fetch in the marketplace. Market value is also commonly used to refer to the market capitalization ...
  6. Preference Shares

    Company stock with dividends that are paid to shareholders before common stock dividends are paid out. In the event of a ...
Trading Center