VBA For Microsoft Excel

This course will teach programming concepts and how to add functionality to a Microsoft Excel using Microsoft Visual Basic® for Applications.

At Course Completion:

• Use the programming capabilities of Microsoft Visual Basic for Applications in Microsoft Excel applications to write custom functions and event-driven procedures. 
• Validate data.
• Find and trap errors.
• Loop through the collection of cells and worksheets to process some calculation.

Prerequisites:

• Before beginning this course, students should be able to:
• Extensive understanding of Microsoft Excel or previous version of Microsoft Excel
• Basic programming knowledge in Visual Basic.

Course Outline:

• Module 1
• Creating a Simple Macro
• Changing Multiple Properties at Once
• Manipulating Recorded Properties
• Editing A Recorded Macro
• Make a Macro Do Simple Tasks
• Module 2
• Task One : Importing a Report file
• Task Two : Filling In Missing Labels
• Make a Macro Do Complex Tasks
• Module 3
• What is an object?
• Understanding Workbooks
• Understanding Worksheets
• Explore Workbooks and worksheets
• Module 4
• Referring to a Range
• Enhancing Recorded Selections
• Entering Values and Formulas into a Range
• Formatting a Range
• Module 5
• Using Conditionals
• If-Then-Else
• Select-Case
• Do…Loop
• For…Next
• For Each…Next
• Control Visual Basic
• Creating Loops
• Module 6
• Creating a Custom Function
• Type Of Errors
• Error Handling
• User Define Function and Error Trapping
• Module 7
• Creating Command Buttons
• Assigning Macro to Button