IT and Computing > Visual Basic for Application (VBA) for Programmer

Visual Basic for Application (VBA) for Programmer

Course Objectives

This course is aimed to introduce some of the challenging aspects of VBA programming which is not normally known by new VBA programmer
At the end of the course, participant will be able to write more advance VBA code.

Target Audience

This program will be conducted with interactive lectures, PowerPoint presentation, discussions and practical exercise

Methodology

This program will be conducted with interactive lectures, PowerPoint presentation, discussions and practical exercise

Course Modules

Module 1 – Building Blocks In VBA

Modular and Event Driven Concepts
Modules
Class Model
User Form
Document Model

Module 2 – Parameter Passing Mechanisms

Parameter Passing Mechanisms
Optional Parameter
Named Parameter
Variable Parameter with ParamArray

Module 3 – Subroutines, Functions, Event

Handlers and Macro

When to use which?
Return value from function
Termination
Macro: A special form of Sub
Event handler: A special form of Sub

Module 4 – Advanced Array Handling

Multi-Dimensional Array
LBound and UBound functions
Redim
Redim Preserve

Module 5 – Advanced Types

Variant
Using Type
Object
Predefined Constants

Module 6 – Options

Option Base
Option Explicit
Option Compare
Option Private

Module 7 – Error Handling

On Error
On Error Goto
On Error Resume Next

Module 8 – Special Constructs

For Each
Abnormal termination with Exit keyword

Module 9 – User Form

The purpose
How to Declare?
How to call it?

Module 10 – Class Module

The Purpose
Properties Declaration
How to use it?

Module 11 – Document Model

Dealing with events
Event Parameters

Module 12 – Advanced Topics

Using Declare keyword to extend VBA ability using external DLL
Advanced Techniques
Security Concerns
Common Pitfalls
Good Practices

Get To Know The Trainer

Trainer Lim

Lim has been working in the IT industry for the past 20 years. He leads, plans and supports a functionally organized, technically oriented team and environment with a wide variety of technical activities and service operations.He is good in developing and implementing IT initiatives for regional service operation activities and actively participates in global projects to align corporate/regional direction and IT standard according to ITIL operational framework and software development.

VIEW PROFILE

Trainer CK

4.5

CK has been involved in Microsoft Office Consulting for more than 15 years with the intention of helping friends and working adults to reach their full capability which in return will increase their work productivity. Throughout his many years of working experience using Microsoft Office Applications, he participated with various projects involving Engineering Data Analysis, A Complete System for Employees such as Leave Application, Petty Cash Claim, Arranging Schedule and so on with Programming using VBA Programming.

VIEW PROFILE

Trainer P.L

4.5

She is an expert on Microsoft Applications, Publisher (Version 2000, XP, 2003 & 2007, VBA, Introduction To Internet, Multimedia Fundamentals, IT Skills For Non-PC Users, Basic IT skills and related programs. In her previous company, she was responsible for developing training courseware and customizing training curriculum.

VIEW PROFILE

View more trainers