VBA Macro 2013

Course Duration

16 hours, 2-day training workshop

Delivery

Face to face training or online training

Course Inclusive

Training materials & certificate of completion

Course Content

  • Module I: Recording Macros
    1. Exploring Macro Security
    2. Recording and Running a Macro
      1. Using Relative Reference
    3. Assigning a Macro to an Image or Button

  • 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 Module
    1. Design Strategies
    2. Error Handling
    • MAKATI
    • 333 Sen. Gil Puyat Ave., Makati City 1200, Philippines

    • Contact No.
    • +63 2 8891 0713
      +63 2 8751 6482

    • Email Address
    • inquiries@mapua.edu.ph

    • INTRAMUROS
    • 658 Muralla St., Intramuros, Manila 1002, Philippines

    • Contact No.
    • +63 2 8524-5572


    • Email Address
    • ccesc@mapua.edu.ph