NoScript Tracker
This training is offered in both face-to-face and distance learning formats. More information

Description

Objectives

After the training the participant shall be able to:

  • program with Visual Basic (VBA) in Excel.
Programme
  • 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
Prerequisites

Good Windows and Excel skills


Conditions

Course Material

The training material will be handed out at the beginning of the course.

Certificate

At the end of the training, the participant will receive a certificate of attendance delivered by the House of Training.

Location
Key Job S.A.
65, Avenue de la Gare
L-1611 Luxembourg
Luxembourg
Calculate the itinerary

Sessions and schedules

Download the schedule (PDF)

  • Thu 19.12.2024

    09:00 to 16:00

    6H

    Excel VBA (Visual Basic) - Fundamentals

    Key Job S.A.

  • Fri 20.12.2024

    09:00 to 16:00

    6H

    Excel VBA (Visual Basic) - Fundamentals

    Key Job S.A.