Excel VBA - Adv
Enquire About This Course
We are currently delivering Online Excel VBA training via our Virtual Classroom - see our websites for more info:
https://www.mullanvirtualtraining.co.uk
https://powerbi-trainingbelfast.co.uk
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
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
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 download:
Microsoft Excel VBA Advanced
Enquire About This Course