SAVE – Special Offers – Click Here...
Latest News
SAVE – Special Offers – Click Here...

Excel VBA - Adv

Enquire About This Course

Excel VBA - Advanced Course Outline

Brief Overview of Previous Course

  • Consolidate areas of the Previous Course(s)

Excel VBA Advanced training courses in Belfast City Centre Northern Ireland

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

Advanced Excel VBA Training Belfast NI - by Mullan Training

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
Latest News
SAVE – Special Offers – Click Here...