Peltier Technical Services, Inc.
 
 

Advanced Excel Charting VBA Class

Developed by Jon Peltier of Peltier Technical Services, the Advanced Excel Charting 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.

Automating Excel Charting with VBA

  • Record Macros to Create and Format Charts 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 User Select Chart Data and Chart Position
    • Let User Select Chart Options from a Custom Dialog
  • Improve your Programming Technique
    • Variables
    • VB Structural Elements
    • The Chart's Object Model
    • Chart-Specific Coding Considerations
    • VBA Programming Tools
  • Modular (Reusable) Procedures
  • VBA for Charting 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.