Excel VBA Application Development Training

Microsoft Excel VBA Training Course Microsoft® Excel VBA Level 2 Training
By TED Integrated
Course Title:
Microsoft® Excel VBA Level 2: Developing Macro Applications
Training Category:
Information Technology
Target Audience:
Those who have completed Microsoft Excel VBA Fundamentals of Macro. Participants must possess good understanding on Excel object structure, looping and decision making statement, variable declaration and comfortable to work with Visual Basic Editor.
Duration:
2 Days
Public Training Events
Apr 2017 ›
Venue:
TED Integrated, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Mon 17 Apr 2017 - Tue 18 Apr 2017
9:00AM - 5:00PM

Fee Per Person:
RM1,400.00
Promotions:
  • 10% discount for group registration of 3 paxs or more from the same organization.
Register Now!

* Other terms & conditions apply.
Aug 2017 ›
Venue:
TED Learning Centre, Binjai 8, Kuala Lumpur, Malaysia
Schedule:
Mon 28 Aug 2017 - Tue 29 Aug 2017
9:00AM - 5:00PM

Fee Per Person:
RM1,500.00
Promotions:
  • 10% discount for group registration of 3 paxs or more from the same organization.
Register Now!

* Other terms & conditions apply.
Nov 2017 ›
Venue:
TED Learning Centre, Binjai 8, Kuala Lumpur, Malaysia
Schedule:
Mon 27 Nov 2017 - Tue 28 Nov 2017
9:00AM - 5:00PM

Fee Per Person:
RM1,500.00
Promotions:
  • 10% discount for group registration of 3 paxs or more from the same organization.
Register Now!

* Other terms & conditions apply.

Course Introduction ›

This course touches on aspects of developing macros for practical applications. New and advanced tools have been included in this course. At the end of the day, two simple applications will be built using techniques covered in the Fundamental level.

Course Objectives ›

After completing this 2-day Macro VBA application development training, participants should be able to:

  • Write advanced VBA Programming.
  • Develop practical Macro applications.
  • Learn new and advanced tools such as custom function, working with user forms, creating custom menus and building Add-Ins.

Prerequisites ›

Completion of Microsoft Excel VBA (Fundamentals of Macro). Participants must possess good understanding on Excel object structure, looping and decision making statement, variable declaration and comfortable to work with Visual Basic Editor.

Course Outline ›

DAY 1

Module 1: Building User Interactive Applications

  • Introduction
  • Message Box
  • Input Box
  • The Excel Inputbox Method

Module 2: More VBA Programming Fundamentals

  • With...End Statement
  • GoTo Statement
  • Select Case Statement
  • Using Arrays
  • Creating Multi-Dimensional Array

Module 3: Creating Custom Functions

  • Introduction
  • Function examples
  • Categorising & Adding Function Description

Module 4: Working with User Forms

  • Introduction
  • Inserting a New Userform
  • Adding controls to a Userform
  • Setting A Control's properties
  • Creating a Userform: An Example
  • Adding More Controls to the Toolbox
DAY 2

Module 5: Creating Custom Menus

  • Userform "Menu"
  • Tool Bar "Menu"
  • Command Bar Menu
  • Creating A Short Cut Key
  • Adding & Deleting Menu Automatically

Module 6: Building Add-Ins

  • What Is An Add-In?
  • Creating An Add-In

Module 7: Exercises

  • Loan Calculator Application
  • Data Entry Application

Contact us now ›

Related Courses ›

Published by: ,