Introduction to Excel VBA
Tailor-made trainingYou 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
- The VBE (Visual Basic Editor)
- Types of variables
- Procedures and functions
- Inputbox and Msgbox
- Decision structures
- Error Handling
- 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
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).