Using the Select Case.'Excel/VBA for Creative Problem Solving, Part 1' is aimed at learners who are seeking to augment, expand, optimize, and increase the efficiency of their Excel spreadsheet skills by tapping into the powerful programming, automation, and customization capabilities available with Visual Basic for Applications (VBA). 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. Microsoft Technical Certification (Role-based)Įxcel Programming with VBA Course Outline Overview.

Visual basic for excel classes