Courses

* National Day Offer Save S$154 for Programming Courses. Other Courses Save S$54. Offer ends on 08/08/2019!

 

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$450

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: 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 8: 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 9: 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$450
Time Slot
Please call 63360244/96503505
or
mail to info.sg@gteceducation.com
We also provides flexible timing to meet the customer's requirement

Request For Brochure

Captcha

Frequently asked questions

No data found