|
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
|