713.589.2655
Houston, Texas

210.568.3904
San Antonio, Texas


Course Links

training schedule
 
  •  Houston
 
  •  San Antonio
training schedule
training schedule

Resources

training schedule
training schedule
training schedule


 

 


 

 

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

   
     

                                                         |   Home   |   Email Us   |   Privacy Notice   |   Site Map   |