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

    Calculating Days Working Capital

    A company’s days working capital ratio shows how many days it takes to convert working capital into revenue.
  6. Professionals

    Career Advice: Accountant Vs. Controller

    Learn about the differences between controllers and accountants, how the two are related and which is the best career choice for aspiring bookkeepers.
  7. Professionals

    What is Cash Basis Accounting?

    Cash basis accounting recognizes revenues and expenses at the time cash is paid or received.
  8. Entrepreneurship

    What's a Good Profit Margin for a Mature Business?

    How to determine if the amount you clear dovetails with the competition.
  9. Investing

    How Spotify Uses Scrum & Agile Methodology To Win The Internet

    Agile processes attempts to deal with the unpredictable nature of the development cycle by identifying errors and eliminating the need to restart the project completely.
  10. Economics

    Understanding Explicit Costs

    Common examples of explicit costs include wages, utilities, rent, raw materials, and other direct expenses companies pay to conduct business.
  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 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 >>
  3. 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 >>
  4. 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 >>
  5. 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 >>
  6. 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 >>

You May Also Like

Hot Definitions
  1. Capitalization Rate

    The rate of return on a real estate investment property based on the income that the property is expected to generate.
  2. Gross Profit

    A company's total revenue (equivalent to total sales) minus the cost of goods sold. Gross profit is the profit a company ...
  3. Revenue

    The amount of money that a company actually receives during a specific period, including discounts and deductions for returned ...
  4. Normal Profit

    An economic condition occurring when the difference between a firm’s total revenue and total cost is equal to zero.
  5. Operating Cost

    Expenses associated with the maintenance and administration of a business on a day-to-day basis.
  6. Cost Of Funds

    The interest rate paid by financial institutions for the funds that they deploy in their business. The cost of funds is one ...
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!