
It supersedes and expands on the abilities of earlier application-specific macro programming languages such as Word's WordBASIC. Visual Basic for Applications enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is used for professional and end-user development due to its perceived ease-of-use, Office's vast installed userbase, and extensive legacy in business.

Although based on pre-.NET Visual Basic, which is no longer supported or updated by Microsoft, the VBA implementation in Office continues to be updated to support new Office features.

Visual Basic for Applications ( VBA) is an implementation of Microsoft's event-driven programming language Visual Basic 6.0 built into most desktop Microsoft Office applications. Using the Select Case.Static/Dynamic Hybrid, Strong/Weak Hybrid Working with the Code Editor Understanding ObjectsĬreating an Event Procedure Using Expressions, Variables, and Intrinsic Functionsĭeclaring and Using Object Variables Controlling Program Execution Using the Immediate Window to Call Procedures Understanding Macro Security Working with Procedures and Functions Understanding the Development Environment Introducing Visual Basic for Applicationsĭisplaying the Developer Tab in the RibbonĮditing a Macro in the Visual Basic Editor For details on this alternative class, go to Excel Macros *** NOTE: A One-Day Version of this Class is also Available for Non-Programmers***ĭon't need to create complex procedures? Just need to automate routine Excel tasks? Consider our one-day Excel Macros course. As well, debugging and error handling techniques are reviewed. The PivotTable object is used to create macros that add interactivity to the standard Pivot Table. Participants create procedures and functions using the VBA language and Excel objects. Students learn the Visual Basic for Applications language as well as the Excel classes and objects needed to create VBA scripts to automate Excel.

