Peltier Technical Services, Inc.
 
 

Intermediate Excel VBA Class

Developed by Jon Peltier of Peltier Technical Services, the Intermediate Excel VBA class is a hands-on experience, scheduled to take three to four hours. The class assumes an intermediate level of competency in Excel, and builds on this base to develop strong skills. Students work on practical examples using their own notebook computers. Class materials include presentations and workbooks, as well as a handful of helpful utilities.

Intermediate Automation of Excel with VBA

  • 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

Contact Peltier Technical Services

Contact Peltier Tech

  • to get information on upcoming training programs,
  • to schedule a training program at your facility,
  • to customize a training program to meet the needs of your organization.
 

Peltier Technical Services, Inc.

Training | Excel Chart Add-Ins | Peltier Tech Blog

Peltier Technical Services, Inc., Copyright © 2010. All rights reserved.
You may link to this article or portions of it on your site, but copying is prohibited without permission of Peltier Technical Services.