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. How does transfer pricing help business?

    Transfer pricing involves the trade of goods or services between two related companies, and both can come out the winner. ... Read Full Answer >>
  3. How do I calculate my effective tax rate using Excel?

    Your effective tax rate can be calculated using Microsoft Excel through a few standard functions and an accurate breakdown ... Read Full Answer >>
  4. How important are contingent liabilities in an audit?

    Contingent liabilities, when present, are very important audit items because they normally represent risks that are easily ... Read Full Answer >>
  5. How does quantifying fixed overhead volume variance show whether a company is profitable ...

    Fixed overhead volume cannot definitively prove a company is profitable, but it can be used to provide an excellent indication ... Read Full Answer >>
  6. What does inventory turnover tell an investor about a company?

    The inventory turnover ratio determines the number of times a company's inventory is sold and replaced over a certain period. ... 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. 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.
  6. Economics

    How to Do a Cost-Benefit Analysis

    The benefits of a given situation or business-related action are summed and then the costs associated with taking that action are subtracted.
  7. Professionals

    How Financial Advisors Pick Client Investments

    How advisors choose investment portfolios is varied, and investors are wise to check with theirs to find out how he or she makes their investment choices.
  8. Entrepreneurship

    Spotify's Agile Management

    Spotify’s entire business structure has maintained an agile mindset despite having 30 teams spread across three cities.
  9. Investing

    Scrum & Agile Methodology Explained

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

    The Pros & Cons Of Using Coupons For Your Business

    Coupons can drive business to your store – you just need to make sure it's profitable business. Here are strategies that work.

You May Also Like

Hot Definitions
  1. 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 ...
  2. Moving Average - MA

    A widely used indicator in technical analysis that helps smooth out price action by filtering out the “noise” from random ...
  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. Productivity

    An economic measure of output per unit of input. Inputs include labor and capital, while output is typically measured in ...
  5. Variance

    The spread between numbers in a data set, measuring Variance is calculated by taking the differences between each number ...
  6. Terminal Value - TV

    The value of a bond at maturity, or of an asset at a specified, future valuation date, taking into account factors such as ...
Trading Center