jQuery - Hands-On

  • You Will Learn How To
  • Hands-On Experience Includes
  • Course Content
vba
  • Design custom solutions, automate tasks and increase performance
  • Apply object models to program efficiently in the Office System
  • Enhancing the Microsoft Office Ribbon with new functionality
  • Troubleshoot code using debugging tools
 
   
   
   

  • Building user interfaces with standard & custom controls
  • Recovering from user errors
  • Adding subtotaling to an Excel workbook
  • Creating form letters and mail with userforms
 
 
Introduction
  • The advantages of VBA
  • Macros: the first step
Getting to Know the VBA Environment
  • The code design tools
  • The debugging tools
Writing VBA Code
  • Putting objects to work
  • Storing data in variables
  • Looping through code
Empowering VBA through the Application Object Models
  • Understanding object model structures
  • Writing application-specific procedures
 
 
 


* If a more detailed course outline, please contact us.

Courses Offered