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

INCLUSIONS

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

Where:

Mpower Learning Manila

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

Outline

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