Microsoft^® Excel VBA Level 2: Developing Macro Applications

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.

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.

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.

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

• 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