Print

Excel VBA - Visual Basic: Fundamentals

Inter-company training
House of Training - Voir la fiche de cet organisme

How long does the training course last?

 12,00 hours(s)

In which language(s) is the training course taught?

EN

When will the next session take place?

Who is organising this training course?

Fondation créée en 2015 par la Chambre de Commerce et l’Association des Banques et Banquiers Luxembourg (ABBL), la House of Training est un organisme agréé de formation professionnelle continue qui s'engage à contribuer activement à la compétitivité et à l'attractivité du Luxembourg en développant les compétences de ceux qui font vivre son économie.

What are the prerequisites?

Good Windows and Excel skills

What are the aims or the skills being targeted?

After the training the participant shall be able to:

  • program with Visual Basic (VBA) in Excel.

What does the training course cover?

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

What will you receive at the end of the training course?

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

How to contact the training provider?

House of Training

These courses might interest you

EN
Day

Excel - Pivot Tables

L'adresse sera fournie ultérieurement
Software - Office software - Spreadsheet software - Excel software
09.12.2026