Microsoft Excel VBA Advanced

MODULE 1: Advanced Procedures

Learning outcomes:

Explore the more advanced options of sub and function procedures to create more flexible programs

Topics covered:

• Calling Procedures
• Passing Values to Procedures

MODULE 2: Advanced Variables

Learning outcomes:

Introduce advanced variable types to store data arrays and simplify the control of objects

Topics covered:

• Understanding Variable Scope
• Understanding Object Variables
• Creating Array Variables
• Creating Dynamic Array Variables

MODULE 3: Interacting with Office Applications

Learning outcomes:

Gain an introduction into the use of VBA to control other office applications to create letters and presentations

Topics covered:

• Setting References to other Applications
• Setting References using Late Binding
• Create a PowerPoint Presentation
• Create a Letter in Word

MODULE 4: Debugging and Error Traps

Learning outcomes:

Using VBA's debugging tools to find and correct errors in code, react to un-foreseen problems

Topics covered:

• Review of Error Types
• Debugging tools
• Setting Error Traps

MODULE 5: Creating Custom User Forms

Learning outcomes:

Use the VBA editor to create custom forms and controls, to gather and validate information from the user

Topics covered:

• Creating a Custom Form
• Adding Form Controls
• Creating Event Procedures

MODULE 6: Workbook and Worksheet Events

Learning outcomes:

Explore the use of Workbook and Worksheet events to react to the users actions and help control your application

Topics covered:

• Create Workbook Events
• Create WorkSheet Events