Friday, August 5, 2016

VBA Environment Introduction

What is VBA?

The Microsoft Visual Basic for Applications window displays your VBA environment in Excel 2013:
Microsoft Excel
VBA standards for Visual Basic for Applications and is the language embedded within your spreadsheet in Excel 2013.
You can only use VBA if you have saved your workbook as an Excel Macro-Enabled Workbook (or xlsm file).
Microsoft Excel
You use VBA in Excel whenever you do one of the following:
  1. Record a macro.
  2. Run a macro.
  3. Create a new function.
  4. Create a new subroutine.
  5. Define a variable.
  6. Place code on the click of a button.