ABSTRACT
VBA, which stands for Visual Basic for Applications, is a programming language developed by Microsoft Corporation. VBA is embedded in several Microsoft Office products, including Word, Excel, PowerPoint, and Visio to augment their capabilities. Other products, such as the Arena system simulation software, also provide an interface to handle VBA to further enhance their functionalities. While VBA is implemented in many applications, this chapter will primarily focus on Microsoft Excel 2013 to illustrate VBA fundamentals. After familiarizing with VBA’s object models in Excel, this chapter will cover how to work with VBA, which includes Visual Basic Editor (VBE), an editor environment for VBA development; Windows Forms and Controls in VBA; various VBA procedures; and some VBA programming essentials. Lastly, the use of VBA functions and the integration of Excel’s built-in worksheet functions into VBA are discussed.
