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