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

• 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

Click here to download:

Microsoft Excel VBA Advanced

Enquire About This Course