Excel VBA - Adv

Enquire About This Course

We are currently delivering Online & Classroom Excel VBA Advanced training - Classroom Based Training is delivered at our Belfast City Centre Premises in Amelia Street (based just opposite the Europa Hotel):

• View info on Course Content & Public Schedule Dates
• View the location of our Belfast City Centre Training Suites
• Visit mullanittraining.co.uk for more details

 

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