VBA in Excel 2002 3 Days £695       Target Audience: Those who wish to make use of the more powerful facilities in Excel made available by VBA. Prerequisites: A thorough understanding of Excel 2000 gained though attendance on the Advanced course or commensurate knowledge through practical experience. Macros revision & summary Relative References in Macros Assigning Macros Visual Basic Editor & The Project Explorer Procedures & Inserting Comments Printing a Visual Basic Mode The Cells and Range Property Flexible Ranges & Range Contents Activating a Workbook and Worksheet Controlling Objects with their Properties Performing Actions with Methods Performing Multiple Actions on an Object Variables, Data Types and Constants Conditional and Looping Control Structures Non-Structured Statements & Subprocedures Built-In and Pre-Defined Dialogue Boxes Custom, Worksheet and User Defined Forms Adding Form Controls & Form Control Properties Control and Dialogue Box Events Displaying and Dismissing a User Form Handling Form Controls The Windows Registry; Settings Files WritePrivateProfileString Error, Break Mode; Instant Watch Stepping and Error Handling Worksheet Object Events User defined Functions & Creating an Add-In Use Form Controls; Memory Variables.