Excel VBA Adv
Starting dates and places
Description
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 VariableM
- Object Variables
Using Visual Basic Functions
- Using A Set Statement
Building Formulae Control Structures
- Case Decision Structures
- Case Else
- Comparison Operators With 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 Inf…
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
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 VariableM
- Object Variables
Using Visual Basic Functions
- Using A Set Statement
Building Formulae Control Structures
- Case Decision Structures
- Case Else
- Comparison Operators With 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
Share your review
Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.