Autocad 2D Weekend Batch Commencing on 30 January 2022!

Interior Designing online weekend course commencing on 5 Feb 2022!

Diploma in Computer Science Part Time Batch Commencing in the month of February 2022!  

Please call on 96503505 or email to for booking.


More Info
VBA Macro Programming

This course helps the participants to automate their daily tasks and reports. Participants are exposed to various Excel objects models to manipulate and control the applications, worksheets and ranges. This beginner level training helps the participants to apply the VBA language to automate tasks and to build a better workflow in their work.

Course Name Duration Entry Requirement Fee (SGD)
VBA Macro Programming 15 hrs Excel (Basic to Intermediate) S$590

For alternate time slots, please call 63360244/96503505

Course Content

Module 1: Getting Started with VBA Excel
  • Introducing Visual Basic for Applications
  • Displaying the Developer Tab in the Ribbon
  • Recording a Macro
  • Saving a Macro-Enabled Workbook
  • Running a Macro
  • Editing a Macro in the Visual Basic Editor
  • Understanding the Development Environment
  • Using Visual Basic Help
  • Closing the Visual Basic Editor
  • Understanding Macro Security
Module 2: Working with Procedures and Functions
  •  Understanding Modules
  • Creating a Standard Module
  • Understanding Procedures
  • Creating a Sub Procedure
  • Calling Procedures
  • Using the Immediate Window to Call Procedures
  • Creating a Function Procedure
  • Naming Procedures
  • Working with the Code Editor
Module 3: Understanding Objects
  •  Understanding Objects
  • Navigating the Excel Object Hierarchy
  • Understanding Collections
  • Using the Object Browser
  • Working with Properties
  • Using the With Statement
  • Working with Methods
  • Creating an Event Procedure
Module 4: Using Expressions, Variables, and Intrinsic Functions
  • Understanding Expressions and Statements
  • Declaring Variables
  • Understanding Data Types
  • Working with Variable Scope
  • Using Intrinsic Functions
  • Understanding Constants
  • Using Intrinsic Constants
  • Using Message Boxes
  • Using Input Boxes Declaring and Object Variables
Module 5: Event Programming
  • Creating a Custom Button to execute code
  • Understanding Event Parameters
  • Working with Worksheet Events
  • Working with Workbook Events
Module 6: Controlling Program Execution
  • Understanding Control-of-Flow Structures
  • Working with Boolean Expressions
  • Using the If…End If Decision Structures
  • Using the Select Case…End Select Structure
  • Using the Do…Loop Structure
  • Using the For…To…Next Structure
  • Using the For Each…Next Structure
  • Guidelines for use of Control-of-Flow Structures
Module 7: Arrays
  • Array Declaration
  • Assigning values to Array
  • Multidimensional Arrays
  • Array Methods
Module 8: Working with Forms and Controls
  • Understanding UserForms
  • Using the Toolbox
  • Working with UserForm Properties, Events, and Methods
  • Understanding Controls
  • Setting Control Properties in the Properties Window
  • Working with the Label Control
  • Working with the Text Box Control
  • Working with the Command Button Control
  • Working with the Combo Box Control
Module 9: Working with the PivotTable Object
  • Understanding PivotTables
  • Creating a PivotTable Using Worksheet Data
  • Working with the PivotTable Objects
  • Working with the PivotFields Collection
  • Assigning a Macro to the Quick Access Toolbar
Module 10: Creating Charts
  • Charting in Excel
  • Referencing Charts Objects using VBA
  • Creating and Modifying the Chart.

No data found

Course Name Duration Entry Requirement Fee (SGD)
VBA Macro Programming 15 hrs Excel (Basic to Intermediate) S$590
Time Slot
Please call 63360244/96503505
mail to
We also provides flexible timing to meet the customer's requirement

Request For Brochure


Frequently asked questions

No data found