Excel VBA Adv

Total time

Excel VBA Adv

Mullan Training
Logo Mullan Training

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

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…

Read the complete description

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
There are no reviews yet.

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.