Visual Basic For Applications - VBA


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.

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

    A claim against a property by a party that is not the owner. ...
  6. Profit and Loss Statement (P&L)

    A financial statement that summarizes the revenues, costs and ...
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 Appreciation

    Appreciation refers to an increase over time in the value of an investment or asset.
  6. Economics

    Calculating Long-Term Debt to Total Assets Ratio

    A company’s long-term debt to total assets ratio shows the percentage of its assets that are financed with long-term debt.
  7. Economics

    Explaining Like-for-Like Sales

    Companies use like-for-like sales figures to compare sales volume from one period to another.
  8. Investing

    How Worried Should We Be About China?

    An economic slowdown, a freezing up in trade and plunging markets and currencies are casting a shadow across Asia—and the globe. How worried should we be?
  9. Investing

    How To Create a Winning Elevator Pitch

    Whether you are talking to potential investors, partners, customers or employees, the skill of being able to concisely summarize your business is critical.
  10. Professionals

    Career Advice: Accountant Vs. Financial Planner

    Identify the key differences between a career in accounting and financial planning, and learn how your personality dictates which is the better choice for you.
  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. Do dividends affect working capital?

    Regardless of whether cash dividends are paid or accrued, a company's working capital is reduced. When cash dividends are ... Read Full Answer >>
  3. Do prepayments provide working capital?

    Prepayments, or prepaid expenses, are typically included in the current assets on a company's balance sheet, as they represent ... Read Full Answer >>
  4. Does working capital include salaries?

    A company accrues unpaid salaries on its balance sheet as part of accounts payable, which is a current liability account, ... Read Full Answer >>
  5. What is a profit and loss (P&L) statement and why do companies publish them?

    A profit and loss (P&L) statement, or balance sheet, is essentially a snapshot of a company's financial activity for ... Read Full Answer >>
  6. 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 >>

You May Also Like

Hot Definitions
  1. Ex Works (EXW)

    An international trade term requiring the seller to make goods ready for pickup at his or her own place of business. All ...
  2. Letter of Intent - LOI

    A document outlining the terms of an agreement before it is finalized. LOIs are usually not legally binding in their entirety. ...
  3. Purchasing Power

    The value of a currency expressed in terms of the amount of goods or services that one unit of money can buy. Purchasing ...
  4. Real Estate Investment Trust - REIT

    A REIT is a type of security that invests in real estate through property or mortgages and often trades on major exchanges ...
  5. Section 1231 Property

    A tax term relating to depreciable business property that has been held for over a year. Section 1231 property includes buildings, ...
  6. Term Deposit

    A deposit held at a financial institution that has a fixed term, and guarantees return of principal.
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!