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. Horizontal Line

    A line that appears to proceed from left to right, or parallel ...
  6. Accountant

    A professional who performs accounting functions such as audits ...
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. Professionals

    Project Manager: Career Path & Qualifications

    Learn more about what project managers job, the qualifications necessary for the position and the most common careers for these professionals.
  6. Professionals

    Common Interview Questions for Financial Auditors

    Identify questions commonly asked at financial auditor job interviews, and learn to formulate winning responses that give your candidacy a boost.
  7. Investing

    What a Family Tradition Taught Me About Investing

    We share some lessons from friends and family on saving money and planning for retirement.
  8. Professionals

    4 Must Watch Films and Documentaries for Accountants

    Learn how these must-watch movies for accountants teach about the importance of ethics in a world driven by greed and financial power.
  9. Active Trading

    An Introduction To Depreciation

    Companies make choices and assumptions in calculating depreciation, and you need to know how these affect the bottom line.
  10. Entrepreneurship

    10 Ways to Be a Successful Entrepreneur

    Are you hoping to launch your own business and work for yourself? If so, here are the top 10 tips for entrepreneurs.
  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. Can working capital be depreciated?

    Working capital as current assets cannot be depreciated the way long-term, fixed assets are. In accounting, depreciation ... Read Full Answer >>
  3. Do working capital funds expire?

    While working capital funds do not expire, the working capital figure does change over time. This is because it is calculated ... Read Full Answer >>
  4. How much working capital does a small business need?

    The amount of working capital a small business needs to run smoothly depends largely on the type of business, its operating ... Read Full Answer >>
  5. What does high working capital say about a company's financial prospects?

    If a company has high working capital, it has more than enough liquid funds to meet its short-term obligations. Working capital, ... Read Full Answer >>
  6. How can working capital affect a company's finances?

    Working capital, or total current assets minus total current liabilities, can affect a company's longer-term investment effectiveness ... Read Full Answer >>

You May Also Like

Hot Definitions
  1. Bar Chart

    A style of chart used by some technical analysts, on which, as illustrated below, the top of the vertical line indicates ...
  2. Bullish Engulfing Pattern

    A chart pattern that forms when a small black candlestick is followed by a large white candlestick that completely eclipses ...
  3. Cyber Monday

    An expression used in online retailing to describe the Monday following U.S. Thanksgiving weekend. Cyber Monday is generally ...
  4. Take A Bath

    A slang term referring to the situation of an investor who has experienced a large loss from an investment or speculative ...
  5. Black Friday

    1. A day of stock market catastrophe. Originally, September 24, 1869, was deemed Black Friday. The crash was sparked by gold ...
Trading Center