Excel 2007 VBA: Expert

Moving beyond simply recording to true programming, this Excel 2007 VBA Macro Development training course will teach you the fundamentals of macro programming using Visual Basic for Application (VBA). You’ll begin by learning about the crucial Object Model, the application, workbook, worksheets, and range, and even gain a few shortcuts on how to access those objects within your code. Next, you’ll create a simple recorded macro and get an in-depth introduction to VBA editor and all the different tools available to help you program. The course reviews some programming basics, along with teaching you how to create a User Form. By the end of the course, you’ll also know how to properly debug your macro by understanding the difference between a logic error and a syntax error, and by utilizing various tools within VBA editor.
This course includes step-by-step instructions and engaging visuals to help you to advance your macro skills.