Duration
9 days
Session 1
(2pm – 6:30pm)
4 ½ hours
Lesson 1: Getting Started
- Introduction to Macros
- Understanding Macros creation
- Macro recorder
- VBA Coding using Visual Basic Editor
- Enable Developer Tab
- Planning macros
- Recording Macros
- Saving a Macro-Enabled Workbook
- Understanding the Development Environment
- Editing a Macro in the Visual Basic Editor
- Understanding Macro Security
Lesson 2: Working with Procedures & Functions
- Introduction to VBA
- Understanding components of
- Macro creation using VBA codes
- Understanding Modules, Procedures & Functions
Lesson 3: Understanding Objects
- Understanding Objects
- Navigating Excel Object Hierarchy
- Application, Workbooks, Worksheets, Range
- Working with Methods & Properties
Participants will be doing hand-on practice & exercises for each of the lesson.
Session 2
(2pm – 6:30pm)
4 ½ hours
Lesson 3: Understanding Objects (Continue)
- Navigating Excel Object Hierarchy
- Application, Workbooks, Worksheets, Range
- Working with Methods & Properties
Lesson 4: Using Expressions, Variables & Intrinsic Functions
- Understand Expressions & Statements
- Working with Variables & Constant
- Interacting with the user
- Using Inputbox & Messagebox function
- Declaring & Using Object Variables
Participants will be doing hand-on practice & exercises for each of the lesson.
Session 3
(2pm – 6:30pm)
4 ½ hours
Lesson 5: Controlling Program Execution
- Decision making in VBA
- IF..End If & Select Case .. Select statements
- Repeating statements in VBA
- For .. Next & For Each… Next statement
- Do .. Loop structure
- Branching Statements
- Exit, Goto
Participants will be doing hand-on practice & exercises for each of the lesson.
Session 4
(2pm – 6:30pm)
4 ½ hours
Lesson 6: Working with Forms
- Working with UserForms
- Plan a userform
- Understanding Userform controls
- Adding controls to Userform
- Adding Code to Userform events & Controls
Lesson 7: Working with the PivotTable Object
- Understanding PivotTables
- Creating a PivotTable using Worksheet Data
- Working with PivotTable Objects
Participants will be doing hand-on practice & exercises for each of the lesson.
Session 5
(2pm – 6:30pm)
4 ½ hours
Lesson 8: Debugging Code
- Understanding Errors
- Using Debugging Tools
- Setting through Code
- Using Break Mode during Run Mode
Lesson 9: Handling Errors
- Understanding Error Handling
- Understanding VBA’s Error Trapping Options
- Trapping Errors with On Error statement
- Writing Error handling routine
- Working with Inline Error Handling
Session 6 - 8
(2pm – 6:30pm)
4 ½ hours
Project 1 - 3
- Determine the Project Flow
- Determine Input, Output & Processing requirements
- Design macros/procedures for each task
- Write Code for each task
Programme scope, delivery arrangements and suitability are confirmed during enquiry.