MS Excel Macros and VBA Programming

Mpower Learning Manila

Date Time: May 6, 2023 | 8:30 am
Time Zone: GMT+8:00 China Taiwan Time

Total Hours

30 Hrs

This training covers the fundamentals of using macros and VBA programming to automate MS Excel.

May 6 and 13, 2023, 8:30 AM-4:30 PM


    • Two snacks per day
    • One lunch per day
    • handouts
    • certificate


Mpower Learning Manila

222 Vivaldi Residences, 628 EDSA cor Aurora Blvd., Cubao, Quezon City


Part 1. Macro Recording

  • Creating Macros
  • Exploring Macro Security
  • Recording and Running a Macro
  • Using Relative Reference
  • Assigning a Macro to Buttons
  • Using Macro Recording to Create VBA Codes

Part 2. Introduction to VBA

  • Exploring the VBA Interface (Overview)
  • VBA Terminologies
  • Exploring the Properties Window
  • Exploring the Code Window

Part 3. Programming Basics

  • Essential VBA Codes
  • Different Ways of Calling Cells
  • Creating Basic Modules
  • Objects, Properties, and Actions
  • Dealing with Rows, Columns, and Sheets

Part 4. Control Structures

  • Applying Decision Structures
  • If, Then, Else Statement
  • If, Then, ElseIf Statement
  • Solving Repetitive Tasks with Loop Structures
  • For, Next Loop
  • For Each, Next Loop
  • Do Until Loop
  • Applying Control Structures in Excel Programs

Part 5. Creating Your Functions

  • Using IF to Create Functions
  • User-Defined Functions
  • Using MS Excel Functions in VBA


Part 6. Creating Userforms and Userform Events

  • Adding UserForms
  • Adding Form Elements
  • Creating Programs for VBA Events

About the Event