CLASSROOM
TENTATIVE

SCHEDULES


Sep 2, 2017 9:00 am 18:00 pm
Sep 9, 2017 9:00 am 18:00 pm
Sep 16, 2017 9:00 am 18:00 pm
REGISTER NOW

MICROSOFT

VBA MACRO 2010

DESCRIPTION
If you have already have a strong background on Pivot, you are ready to take this course.
COURSE CONTENT

Module I : Macro Overview

  • Macro and Security
  • Macro
  • Running Macro
  • Assigning a Macro to an Image/Button
  • Relative References

Module II : Programming Basics

  • The VBA Interface
  • Essential VBA Codes and Programming Principles
  • Declaring Variables
  • Constants
  • Creating Your Own Functions
  • Editing VBA Codes

Module III : Control Structures

  • Decision Structures
  • Loop Structures
  • Essential VBA Codes + Control Structures

 Module IV : Userforms

  • Creating Userforms
  • Basic Userform Codes
  • Events
  • Sending Data from Userform to Excel (and Vice Versa)
  • Other Userform Proramming

Module V : Debugging and Error Handling

  • Errors
  • Debugging tools

Module VI : Securing VBA Codes

Module VII : More VBA Practice

Module VIII : Advance Excel Exercises

Module IX : Time for Participant’s Questions/Requests