Excel VBA Application Development Training

Microsoft Excel VBA Training Course Microsoft® Excel VBA Level 2 Training
By TED Integrated
Microsoft Excel Series:

Microsoft® Excel VBA Level 2: Developing Macro Applications

“Learn to develop practical Macro Applications with Microsoft Excel VBA!”

By TED Integrated


PSMB Certified Training Provider
Request for In-house TrainingRequest for In-house Training
Register for Public Training Public program not yet available
Email Customer Service [email protected] Contact Customer Service +603-2386-7788
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.
For In-house Training
Request for Quotation Request for Quotation
For Other Inquiries
Contact TED Integrated
Contact customer service +603-2386-7788
Email customer service [email protected]
Delivery Methods
  • Language: English
  • Computer Lab Work
  • Case Studies
  • Certificate of Participation
Ad by Google
*Terms & Conditions

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 ›

  • Course content customization
  • In-house training request
  • Available public program
  • Consultation services
  • Other inquiries
Contact Customer ServiceCall : +603-2386-7788
Email Customer Service E-mail : [email protected]

Related Courses ›

More Other Training Courses ›

Published by: ,