In most cases, this is the same as the active workbook. The ThisWorkbook property of the Application object returns the workbook where the Visual Basic code is running. The Workbooks collection contains all the Workbook objects currently open in Microsoft Excel. The Workbook object is a member of the Workbooks collection. Combine every day excel techniques with VBA to automate the creation of formulas in different sheets and cells.Represents a Microsoft Excel workbook.Iterate through every row on a sheet to perform a complicated calculation that can't be expressed through formulas.Load data from an external data source, like an accounting system. Write a variety of error handling routines.Create procedures that start automatically.

Create a custom form complete with controls and event procedures.Perform loops, controls and other common programming techniques.Create and work with user-defined functions.Create command procedures and use variables.Understand the Excel object model and VBA concepts.The course is generally offered as a 2-day course and can be customized when delivered for private groups to include time working through actual client VBA tasks/projects. This course is intended for advanced Microsoft Excel professionals. This instructor-led course, through lecture and hands-on exploration, will introduce students to the Microsoft Excel Visual Basic for Applications (VBA) programming environment to develop custom solutions and automate routine tasks. Introduction to Microsoft Excel VBA Programming

Visual basic for excel classes