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.

RELATED TERMS
  1. Baby Bills

    A hypothetical nickname for the smaller companies that would ...
  2. Enterprise Application Integration

    The translation of data and other commands from one application ...
  3. Branch Automation

    Form of banking automation that connects the customer service ...
  4. In-App Purchasing

    The purchase of goods and services from an application on a mobile ...
  5. Stock Screener

    A tool that investors and traders can use to filter stocks based ...
  6. Aggregate Function

    A mathematical computation involving a set of values rather than ...
Related Articles
  1. Investing

    The Importance Of Office To Microsoft

    The mobile and cloud revolution were expected to sound the death knell for the Office suite of products, but a new era is beginning for Microsoft Office.
  2. Stock Analysis

    Microsoft's New Reporting Structure: A Closer Look (MSFT)

    Learn about the changes being made to the reporting structure of Microsoft's books and how they will affect the way investors read the company's financials.
  3. Investing

    An Overview of Businesses Owned by Microsoft (MSFT)

    Microsoft is much more than a software company. Here are five businesses owned by the multi-billion dollar conglomerate.
  4. Entrepreneurship

    The Importance of Excel in Business

    Microsoft Excel is an indispensable tool for any business.
  5. Entrepreneurship

    Microsoft

    These companies found success despite being started in economic downturns.
  6. Mutual Funds & ETFs

    Top 4 Mutual Fund Holders of Microsoft (MSFT, VTSMX)

    Discover the top four largest mutual fund owners of Microsoft shares, and determine how their portfolios benefit from these holdings.
  7. Investing

    Candlestick Charts

    Learn more about this common visualization of a stock's price movement most often used by technical analysts.
  8. Stock Analysis

    Microsoft's 3 Key Financial Ratios (MSFT)

    Find out what the important financial ratios for Microsoft are and how they are applied to explain certain aspects of the company's business.
  9. Stock Analysis

    Top 5 Companies Owned By Microsoft (MSFT)

    Find out about Microsoft's most newsworthy acquisitions. Microsoft acquired Skype in 2011 to expand its footprint in the online telecommunications sector.
  10. Investing

    Bill Gates: Success Story

    Before Bill Gates could climb to the top of the PC software market, he had to start with the microcomputer. In the beginning of 1975, when Gates was 20 and newly dropped out of Harvard College, ...
RELATED FAQS
  1. Why was Microsoft subject to antitrust charges in 1998?

    On May 18, 1998, the Department of Justice filed antitrust charges against Microsoft (Nasdaq:MSFT ). The charges were brought ... Read Answer >>
  2. Who are Microsoft's (MSFT) main competitors?

    Discover the main competitors of technology giant Microsoft and the stiff competition facing this industry leader. Find out ... Read Answer >>
  3. What are some of the most prominent companies in the electronics sector?

    Explore some of the most popular, technologically innovative and widely held companies that are prominent in the consumer ... Read Answer >>
  4. What's an easy way of calculating gross sales in Excel?

    Use Excel to calculate gross sales, display sales data, and establish a template that allows for extensive sales calculations ... Read Answer >>
  5. What are some common functions of business intelligence technologies?

    Understand the common functions of business intelligence technologies, and learn how business intelligence is used to increase ... Read Answer >>
  6. How do you the calculate Sharpe ratio in Excel?

    Learn how to use Microsoft Excel to calculate the Sharpe ratio, an investing tool useful for assessing the relationship between ... Read Answer >>
Hot Definitions
  1. Law Of Demand

    A microeconomic law that states that, all other factors being equal, as the price of a good or service increases, consumer ...
  2. Cost Of Debt

    The effective rate that a company pays on its current debt. This can be measured in either before- or after-tax returns; ...
  3. Yield Curve

    A line that plots the interest rates, at a set point in time, of bonds having equal credit quality, but differing maturity ...
  4. Stop-Limit Order

    An order placed with a broker that combines the features of stop order with those of a limit order. A stop-limit order will ...
  5. Keynesian Economics

    An economic theory of total spending in the economy and its effects on output and inflation. Keynesian economics was developed ...
  6. Society for Worldwide Interbank Financial Telecommunications ...

    A member-owned cooperative that provides safe and secure financial transactions for its members. Established in 1973, the ...
Trading Center