Introduction to Excel VBA

Tailor-made training

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

Description

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.

Contents

Macros

  • 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

Forms

  • 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.

Prerequisites

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

Duration

3 days

Prix par participant

1445 EUR
Tailor-made training
Iedere organisatie werkt op een andere manier en geen enkele werknemer is hetzelfde. Wij bieden al onze opleidingen ook op maat van jouw organisatie.
Continue reading