Excel VBA (Visual Basic) - Fundamentals

Betribsiwwergräifend Formatioun

U wie riicht sech d'Formatioun?

All Zilgruppen

Dauer

14,00 Stonn(en)

Sprooch(e) vun der Déngschtleeschtung

EN

Nächst Sessioun

19.12.2024
Plaz
Luxembourg

Präis

740,00€

Virkenntnisser

Good Windows and Excel skills

Ziler

After the training the participant shall be able to:

  • program with Visual Basic (VBA) in Excel.

Inhalt

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

Certificat, Diplom

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

Nächst Sessioun

Datum
Stad
Sprooch & Präis
19.12.2024

20.12.2024
Luxembourg
EN 740,00€

Dës Formatioune kéinten Iech interesséieren

EN
Dag
Blended-Learning
Logiciel - Logiciel Content Management Entreprise - Spreadsheet-Logiciel - Logiciel Excel
05.12.2024
FR
Dag
Classe virtuelle
Logiciel - Logiciel Content Management Entreprise - Logiciel Textveraarbechtung - Logiciel WORD
20.12.2024