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. Operating Cost

    Expenses associated with administering a business on a day to ...
  6. Mobile First Strategy

    Mobile first strategy is trend in website development where designing ...
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 are some examples of a deferred tax liability?

    In the United States, laws allow companies to maintain two separate sets of books for financial and tax purposes. Because ... Read Full Answer >>
  3. Why is the use of contra accounts so important for maintaining ledgers?

    Contra accounts have been used in financial accounting to verify the balance of another corresponding account since Renaissance ... Read Full Answer >>
  4. What impact did the Sarbanes-Oxley Act have on corporate governance in the United ...

    After a prolonged period of corporate scandals involving large public companies from 2000 to 2002, the Sarbanes-Oxley Act ... Read Full Answer >>
  5. How is deferred revenue treated under accrual accounting?

    In accrual accounting, deferred revenue, or unearned revenue, represents a liability on the balance sheet recorded on funds ... Read Full Answer >>
  6. What are some examples of prime cost items?

    In business finance, prime costs are the two types of basic expenses required to produce a product for sale: raw materials ... 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

    What are Accounting Principles?

    The term accounting principles refers to rules and guidelines companies use to help them record their business and financial transactions.
  6. Economics

    Understanding the Accounting Cycle

    An accounting cycle consists of the traditional procedures performed to record business events and transactions in a company’s accounting records.
  7. Fundamental Analysis

    When & Why Should a Company Use LIFO

    By using LIFO (last in, first out) when prices are rising, companies reduce their taxes and also better match revenues to their latest costs.
  8. Fundamental Analysis

    The Importance Of Analyzing Accounts Receivable

    While investors often focus on revenues, net income, and earnings per share, they should not overlook the importance of analyzing accounts receivable.
  9. Markets

    The Story Of Zipdial's Success

    Here is how ZipDial formed and subsequently shot to success in the Asian market.
  10. Investing Basics

    Explaining Write-Downs

    A write-down is a reduction in the book value of an asset because it is overvalued compared to the market value.

You May Also Like

Hot Definitions
  1. Mixed Economic System

    An economic system that features characteristics of both capitalism and socialism.
  2. Net Worth

    The amount by which assets exceed liabilities. Net worth is a concept applicable to individuals and businesses as a key measure ...
  3. Stop-Loss Order

    An order placed with a broker to sell a security when it reaches a certain price. A stop-loss order is designed to limit ...
  4. Covered Call

    An options strategy whereby an investor holds a long position in an asset and writes (sells) call options on that same asset ...
  5. Butterfly Spread

    A neutral option strategy combining bull and bear spreads. Butterfly spreads use four option contracts with the same expiration ...
  6. Unlevered Beta

    A type of metric that compares the risk of an unlevered company to the risk of the market. The unlevered beta is the beta ...
Trading Center