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