Excel 2007: VBA Programming

Course Outline

Duration: 1 Day

Description: This course is designed to give experienced Excel users proficiency in creating procedures that run in response to specific events, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code.

Course Length: One day

Course Content:

Unit 1: Visual Basic Editor

• Topic A: Visual Basic for Applications
• Topic B: Object programming
• Topic C: The Object Browser
  
  

Unit 2: Programming basics

• Topic A: Data basics
• Topic B: Scope of variables
• Topic C: Scope of procedures
  
  

Unit 3: Control structures

• Topic A: Decision structures
• Topic B: Loop structures
  
  

Unit 4: Custom dialog boxes

• Topic A: User forms
• Topic B: Events
  
  

Unit 5: Debugging and error handling

• Topic A: Errors
• Topic B: Debugging
• Topic C: Error handling