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 >>
  2. What is the difference between work in progress (WIP) and finished goods in accounting?

    Work in progress (WIP) and finished goods are broad classification terms used in accounting for inventory to specify the ... Read Full Answer >>
  3. Why should sunk costs be ignored in future decision making?

    A sunk cost is a cost that cannot be recovered or changed and is independent of any future costs a business may incur. Since ... Read Full Answer >>
  4. How is reconciliation treated under generally accepted accounting principles (GAAP)?

    The generally accepted accounting principles, or GAAP, provide different reconciliation rules for balancing many kinds of ... Read Full Answer >>
  5. Where did the concept of reconciliation in accounting come from?

    Financial accountants perform reconciliation to ensure that the balances of two accounts are in agreement. The process by ... Read Full Answer >>
  6. Are all fixed costs considered sunk costs?

    In accounting, finance and economics, all sunk costs are fixed costs. However, not all fixed costs are considered to be sunk. ... 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

    Understanding Carrying Value

    Carrying value is the value of an asset as listed on a company’s balance sheet. Carrying value is the same as book value.
  6. Economics

    International Financial Reporting Standards (IFRS)

    International Financial Reporting Standards are accounting rules and guidelines governing the reporting of different types of accounting transactions.
  7. Economics

    Explaining Property, Plant and Equipment

    Property, plant and equipment are company assets that are vital to business operations, but not easily liquidated.
  8. Economics

    How to Calculate Trailing 12 Months Income

    Trailing 12 months refers to the most recently completed one-year period of a company’s financial performance.
  9. Economics

    What is Unearned Revenue?

    Unearned revenue can be thought of as a "pre-payment" for goods or services which a person or company is expected to produce to the purchaser.
  10. Personal Finance

    How Agile Project Management Changed Zara

    Zara has created a competitive advantage in the retail industry by using a supply chain centered on agile project management.

You May Also Like

Hot Definitions
  1. Adverse Selection

    1. The tendency of those in dangerous jobs or high risk lifestyles to get life insurance. 2. A situation where sellers have ...
  2. Wash Trading

    The process of buying shares of a company through one broker while selling shares through a different broker. Wash trading ...
  3. Fixed-Income Arbitrage

    An investment strategy that attempts to profit from arbitrage opportunities in interest rate securities. When using a fixed-income ...
  4. Venture-Capital-Backed IPO

    The selling to the public of shares in a company that has previously been funded primarily by private investors. The alternative ...
  5. Merger Arbitrage

    A hedge fund strategy in which the stocks of two merging companies are simultaneously bought and sold to create a riskless ...
  6. Market Failure

    An economic term that encompasses a situation where, in any given market, the quantity of a product demanded by consumers ...
Trading Center