Introduction to Excel VBA

3 September 2020
St-Lendriksborre 8
09:00 - 17:00
NL  Dutch
17 September 2020
Noorderlaan 139
09:00 - 17:00
NL  Dutch

Tailor-made training

Would you rather have a tailor-made training based on this course? Contact us and we will make it work.


Excel is a powerful application, but it does have its limitations: for example, every day you have to make the same list, add the totals, the Pivot Tables or charts,… You have to set up the same filter on 15 sheets,… In this course you will learn how to automate all these actions so that with one click of your mouse all the repetitive work is done for you and you can start immediately on your real work.



  • Recording a macro
  • Link a macro to a button

Visual Basic

  • The VBE (Visual Basic Editor)
  • Modules
  • Types of variables
  • Procedures and functions
  • Inputbox and Msgbox
  • Decision structures
  • Loops
  • Error Handling

Excel Objects

  • The Excel Object Model
  • Properties, Methods and Events
  • The application object
  • The workbook(s) object
  • The worksheet(s) object
  • The range object


  • Working with form objects (command button, listbox, checkbox,…)
  • Working with forms in Excel

Target audience

Anyone who regularly carries out the same actions in Excel and would like to know how to automate these actions.


Good knowledge of Excel (Knowledge of Visual Basic is not required).


3 days

Prix par participant

1445 EUR
Tailor-made training
Each organization is unique in its identity, and no co-worker is the same. That's why we at Learnia offer our clients tailor-made courses as well.
Continue reading