VBA Macro 2013

Course Content

Module I: Recording Macros
  1. Exploring Macro Security
  2. Recording and Running a Macro
    1. Using Relative Reference
Module II: VBA Programming
  1. Essential VBA Codes
  2. Using IF in VBA
  3. Creating Loops and Other Decision Structures
  4. Interactive Elements
  5. Other Object Programming
Module III: Functions
  1. Designing Own Functions
  2. Writing Formulas in VBA
  3. Using Excel Functions in VBA
  4. VBA Functions
Module IV:Userforms
  1. Designing Userforms
  2. Adding Operations on Userform 
Module V: Creating Modules
  1. Design Strategies
  2. Error Handling
    • Makati
    • +63 2 8891 0722
    • +63 2 8891 0713
    • +63 2 8751 6482
    • Intramuros
    • +63 2 8524-5572
    • Intramuros
    • 658 Muralla St., Intramuros, Manila 1002, Philippines


    • Makati
    • 333 Sen. Gil Puyat Ave., Makati City 1200, Philippines