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. How do subscription business models work?

    Subscription business models are based on the idea of selling a product or service to receive monthly or yearly recurring ... Read Full Answer >>
  3. How are contingent liabilities reflected on a balance sheet

    Contingent liabilities need to pass two thresholds before they can be reported in the financial statements. First, it must ... Read Full Answer >>
  4. How do businesses determine if an asset may be impaired?

    In the United States, assets are considered impaired when net carrying value (book value) exceeds expected future cash flows. ... Read Full Answer >>
  5. How can I set up an accrual accounting system for a small business?

    First, determine whether accrual accounting makes the most sense practically and financially. If the small business is also ... Read Full Answer >>
  6. Why is work in progress (WIP) considered a current asset in accounting?

    Accountants consider work in progress (WIP) to be a current asset because it is a type of inventory asset. Accountants consider ... 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. Fundamental Analysis

    What is Quantitative Analysis?

    Quantitative analysis refers to the use of mathematical computations to analyze markets and investments.
  6. Economics

    Explaining Residual Value

    Residual value is a measurement of how much a fixed asset is worth at the end of its lease, or at the end of its useful life.
  7. Investing News

    Cost-Free Connection Of Target Groups To Marketers

    ZipDial spotted a niche marketing opportunity in the area of “missed calls” and developed a business around it. Here is how ZipDial works and its benefits.
  8. Fundamental Analysis

    Why Last In First Out Is Banned Under IFRS

    We explain why Last-In-First-Out is banned under IFRS
  9. 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.
  10. Economics

    International Financial Reporting Standards (IFRS)

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

You May Also Like

Hot Definitions
  1. Fisher Effect

    An economic theory proposed by economist Irving Fisher that describes the relationship between inflation and both real and ...
  2. Fiduciary

    1. A person legally appointed and authorized to hold assets in trust for another person. The fiduciary manages the assets ...
  3. Expected Return

    The amount one would anticipate receiving on an investment that has various known or expected rates of return. For example, ...
  4. Carrying Value

    An accounting measure of value, where the value of an asset or a company is based on the figures in the company's balance ...
  5. Capital Account

    A national account that shows the net change in asset ownership for a nation. The capital account is the net result of public ...
  6. Brand Equity

    The value premium that a company realizes from a product with a recognizable name as compared to its generic equivalent. ...
Trading Center