Course outlines may be downloaded for many of the courses.

If you would like additional outlines please do not hesitate to contact us.

Excel VBA - Adv Excel VBA - Advanced Course Outline   Brief Overview of Previous Course §         Consolidate areas of the Previous Course(s)     Excel Objects §         Calling Methods §         Passing Arguments §         Singular Objects & Collections Of Objects     Variables §         Dimensioning A Variable §         Object Variables     Using Visual Basic Functions §         Using A Set Statement       Building Formulae Control Structures §         Select Case Decision Structures §         Case Else §         Comparison Operators With Select Case Structure §         While...Wend Statement     Event Handling §         VBA Editing & Debugging §         Auto Macros §         Error Handling        Running Code §         Run Mode And Design Mode §         Running Code From The Development Environment §         Running Code From The Host Application     Storing Information §         The Windows Registry §         Settings Files §         WritePrivateProfileString     Debugging and Error Trapping §         Errors §         Break Mode §         Instant Watch §         Stepping §         Error Handling §         Error Handling Example     Worksheet and Workbook Events §         Worksheet Object Events     Validations §         Validating The User Inputs §         When To Apply Validation, Control Events     Parsing §          Parsing Control Values Back To A Spreadsheet §         Parsing Range Values To The Userform Controls     Controls §         Creating Template Controls §         Using The Refedit Control §         Finding The Active Control §         Creating Controls At Runtime     Click here to view our Public Schedule & Costs   Excel_VBA Adv