Microsoft® Office Excel 2003: VBA Macros 2

Training Course Content

• More Fundamentals of Excel VBA: The Visual Basic Editor, Objects and Properties
  

• Excel Objects: Object Hierarchy, Application, Workbook, Worksheet, and Range
  
  
• Variables and Constants: Data types, Variable Levels and Declaring Variables
  
  
• Loops: Types of Loops and Using Loops
  
  
• Effective Decision Making: If/And/Or, Select Case
  
  
• Workbook and Worksheet Events
  
  
• Debugging and Error Handling: Error Handling and Prevention
  
  
• Excel Worksheet Functions in VBA: Specific Examples
  
  
• User Defined Functions
  
  
• Worksheet Form Controls: ActiveX, Control Toolbox, Control Properties
  
  
• User Forms Introduction

Excel 2003 Course Outlines:
Level 1 - Fundamentals
Level 2 - Intermediate
Level 3 - Advanced
Level 4 - Exploring Macros
Level 5 - Advanced Macros & VBA