The Intermediate Excel VBA class is a full-day, hands-on experience. The student will learn best practices for working with VBA, and will be able to use VBA to automate routine tasks, both for the student and for others. This class is equivalent to Advanced Excel Charting with VBA, with examples and explanations focused on using VBA for general purposes, with less emphasis on charting.
- Record Macros to Repeat Tasks Automatically
- Understanding the VB Editor
- Visual Basic Elements
- Project Explorer, Properties Window
- Object Browser, Immediate Window, Locals
- VBE Options
- Tweaking Recorded Macros
- Debugging and Error Proofing
- Errors in Recorded Macros
- Error Trapping
- Using a Dialog to Interact with Users
- Let Users Select Simple Options
- Let Users define Complex Options Using a Custom Dialog
- Improve your Programming Technique
- Variables
- VB Structural Elements
- Excel’s Object Model
- VBA Programming Tools
- Modular (Reusable) Procedures
- VBA for Working Across Applications
All classes offered by Peltier Technical Services have been developed by Jon Peltier of Peltier Tech. They assume an intermediate level of competency in Excel, and build on this base to develop strong skills. Attendees work on practical examples using their own notebook computers. Class materials include presentations and workbooks, as well as a handful of helpful utilities.
