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. 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 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 Basics

    What are Financial Statements?

    Financial statements are a picture of a company’s financial health for a given period of time at a given point in time. The statements provide a collection of data about a company’s financial ...
  6. Investing

    The Production Possibility Frontier (PPF)

    A production possibility frontier (PPF) is a range of answers to the question, “What is our maximum production capacity?”
  7. Stock Analysis

    How Will InvenSense Expand Its Gross Margins?

    One of the chief concerns surrounding motion sensor vendor InvenSense is that the company's gross profit margins have come under pressure.
  8. Investing

    The Motley Fool vs. TheStreet: Which Is Which?

    Motley Fool and TheStreet.com provide financial news and other investment services, but each has unique traits that will appeal to different users.
  9. Investing

    What's a Debit Note?

    A debit note is a document used by a seller to inform a purchaser of a dollar amount owed. As the name indicates, it is a note from the seller that a debit has been made to the purchaser’s account. ...
  10. Investing

    What's Capitalization?

    Capitalization has different meanings depending on the context.

You May Also Like

Hot Definitions
  1. Risk Averse

    A description of an investor who, when faced with two investments with a similar expected return (but different risks), will ...
  2. Fixed-Charge Coverage Ratio

    A ratio that indicates a firm's ability to satisfy fixed financing expenses, such as interest and leases. It is calculated ...
  3. Efficiency Ratio

    Ratios that are typically used to analyze how well a company uses its assets and liabilities internally. Efficiency Ratios ...
  4. Fixed Cost

    A cost that does not change with an increase or decrease in the amount of goods or services produced. Fixed costs are expenses ...
  5. Subsidy

    A benefit given by the government to groups or individuals usually in the form of a cash payment or tax reduction. The subsidy ...
  6. Sunk Cost

    A cost that has already been incurred and thus cannot be recovered. A sunk cost differs from other, future costs that a business ...
Trading Center