Duration: 3 days
Time: 9am to 5.30pm

What Will Be Taught For This Microsoft Excel VBA Course?

This course introduces the student in automating and customizing the different processes in Excel through VBA coding. It uses the various Excel Objects Models to manipulate and control the applications, worksheets and ranges. Furthermore, the students will be exposed to the different programming constructs and techniques in handling data from the worksheet.

Through this MS Excel VBA course, the trainee will also learn how to use Events in Excel, VBA Arrays, and creating useful data forms.

Module 1. Introduction To Macros
  • Define a Macro Title
  • Define the relationship between Macros and VBA
  • Open Workbooks containing Macros
  • Set Macros security level
  • Enable and disable Macros
  • Record and store a Macro
  • Specify Macro location
  • Run a Macro
  • Macro Dialog Box
  • Shortcut Key Dialog
  • Customizing Menu Bar and Toolbar
  • Forms Control
  • Visual Basic Editor
Module 2. VBA Environment
  • Familiarize with VBA Environment
  • Using the Edit Toolbar
  • Adding Comments
  • Use the Immediate Window
  • Use the Debug.Print
  • Use ? statement
Module 3. Working With Objects
  • Instructions, Module and Procedures
  • Object, Properties and Methods
  • Syntax Rules
  • The Object Browser
  • MsgBox function
  • InputBox function
Module 4. Variables And Data Types
  • Define Variables
  • Identify built-in Data Types
  • Create Variables
  • Declare Variables
  • Force Declaration of Variables
  • Set Option Explicit
  • User-defined constants
  • Using constants in Variables
Module 5. Operators and Decision Making
  • Relational Operators
  • Logical Operators
  • Using If statements
  • Using ElseIf statement
  • Using Select Case statement
Module 6. Loops
  • Write repetitive or looping statements
  • Do Loop, Do While, Do Until, While Wend
  • For Next loop
  • Exiting Loop
  • Nested Loop
Module 7. Subroutines and Functions
  • Overview
  • Subroutine
  • Function
  • Passing arguments
  • Passing Optional arguments
Module 8. Arrays
  • Introduction to Arrays
  • Declare Array
  • Use Option Base
  • Declare Dynamic Arrays
  • Using 2-D Arrays
  • Use Array functions
  • LBound and UBound functions
  • Erase function
  • Array Function
  • Use ParamArray
Module 9. Custom Forms Dialogs and Events
  • DialogBoxes in Excel
  • Creating UserForms
  • Understanding Form and Events Control
  • Event and Event Procedures
  • Define Event Procedures in Form
  • Workbook Events
  • Worksheet Events
Module 10. Debugging and Error Handling
  • Testing Procedure
  • Stopping a Procedure
  • Stepping through a VBA Procedure
  • Insert Breakpoint
  • Stop statement
  • Add Watch expression
  • Debug Windows
  • Bookmarks
  • On Error statement (Trapping Errors)

Who Should Attend This Microsoft Excel VBA Training?

  • Perfect for experienced Microsoft Office Excel users who wish to expand their skill set for a larger scope of analyst roles.
  • Anyone who may want to automate repetitive tasks or simplify complex tasks using the VBA programming language.

Pre-requisite

Complete the Microsoft Excel Advanced Course.

  w/o GST w GST
Course Fee $900 $963

This course is applicable for Skills Development Fund (SDF).


Remarks:

Individual Sponsored

  • Eligible Singapore Citizens can use their SkillsFuture Credit to offset course fee payable after funding.
  • This course is supported under UTAP funding.
  • This course is eligible for using PSEA funds.

Terms & Conditions

  • All prices stated above are in Singapore Dollars (SGD). This funding support is only applicable for Singapore Citizen and Permanent Residents.
  • Trainee must attained minimum 75% attendance in order to qualify for Funding.
  • Trainee undertakes to reimburse ST Electronics (e-Services) FULL course fees should he/she be ineligible for course fee grant. ST Electronics (e-Services) is not liable for any other funding not approved by WSG.
  • ST Electronics (e-Services) reserves the right to change the date or venue without prior notice.
  • ST Electronics (e-Services) reserves the right to cancel or reschedule the course due to class size or unforeseen circumstances.


Please click on the course date to enrol.