Courses

Enquiries Registration Training Calendar corp-training Corporate Training corp-training Project Training Online training

MS Office Basic Commencing on 04 March 2024 (Classroom Training)

Autocad 2D Commencing on 16 March 2024 (Classroom Training)

Please Call/Whatsapp 96503505 for more details.

 

 

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