Details

Goals

Being able to program with Visual Basic (VBA) in Excel.

Prerequisite

Good Windows and Excel skills.

Contents

Interface

Terminology

  • Key Words
  • Description of an object in VBA

Recording

  • Recording procedure
  • Recording options
  • Manual execution of a macro

Creating a procedure –Subroutine

  • Inserting new modules
  • Inserting a new procedure or function
  • Help in the creation process

The variables

  • Variables accessibility
  • The “Dim as” statement

References and Selections

  • Cell references
  • Object references
  • Selection of a cell or of an object

Interactivity

  • Inputbox
  • Msgbox

Conditions

  • The “IF” Statement
  • The “Select Case” Statement

Loops

  • For…Next
  • Do…Loop

Object manipulations

User Forms

Debugger

  • Step by step execution
  • Break point
  • Watch-Immediate window

Functions

Managing errors codes

Sign up

Next session(s)

Wed. 20 Nov. Thu. 21 Nov. 2024

Wed. 11 Dec. Thu. 12 Dec. 2024

Thu. 19 Dec. Fri. 20 Dec. 2024

Need a custom training?

None of the trainings fit your requirements? You have specific needs? Key Job trainers are versatile and flexible. Contact us!