Microsoft® Excel VBA Level 2: Developing Macro Applications



By TED Integrated
![]() |
![]() |
![]() |
![]() |
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
Jul 2019 ›
TED Learning Centre, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Wed 17 Jul 2019 - Thu 18 Jul 2019
9:00AM - 5:00PM
Fee Per Person:
RM1,590.00
Promotions:
- 10% discount for group registration of 3 paxs or more.
* Other terms & conditions apply.
Aug 2019 ›
TED Learning Centre, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Wed 21 Aug 2019 - Thu 22 Aug 2019
9:00AM - 5:00PM
Fee Per Person:
RM1,590.00
Promotions:
- 10% discount for group registration of 3 paxs or more.
* Other terms & conditions apply.
Sep 2019 ›
TED Learning Centre, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Mon 23 Sep 2019 - Tue 24 Sep 2019
9:00AM - 5:00PM
Fee Per Person:
RM1,590.00
Promotions:
- 10% discount for group registration of 3 paxs or more.
* Other terms & conditions apply.
Oct 2019 ›
TED Learning Centre, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Wed 23 Oct 2019 - Thu 24 Oct 2019
9:00AM - 5:00PM
Fee Per Person:
RM1,590.00
Promotions:
- 10% discount for group registration of 3 paxs or more.
* Other terms & conditions apply.
Nov 2019 ›
TED Learning Centre, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Wed 20 Nov 2019 - Thu 21 Nov 2019
9:00AM - 5:00PM
Fee Per Person:
RM1,590.00
Promotions:
- 10% discount for group registration of 3 paxs or more.
* Other terms & conditions apply.
Dec 2019 ›
TED Learning Centre, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Thu 26 Dec 2019 - Fri 27 Dec 2019
9:00AM - 5:00PM
Fee Per Person:
RM1,590.00
Promotions:
- 10% discount for group registration of 3 paxs or more.
* Other terms & conditions apply.
![]() |
Request for Quotation |
![]() |
+603-2386-7788 |
![]() |
training@ted.com.my |
- Language: English
- Computer Lab Work
- Case Studies
- Certificate of Participation
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 ›
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
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 ›
- Microsoft® Excel VBA for Non-Programmers
- Introduction to PowerPivot 2010
- Maximizing Microsoft® Excel Tools for Fast & Accurate Business Reporting
- Introduction to Power Business Intelligence with Excel 2010
- Microsoft® Excel for Intermediate/Advance User
- More other Information Technology related courses