Skip to main content

Excel: VBA Programming

Version: Office 365
Duration: 3 days
Price incompany training: € 3750 VAT excl. / Terms for incompany training.

Description

Save time with our ‘Excel: VBA Programming’ training

Excel is a powerful application. Have you encountered situations where you had to insert the same data or execute the same actions over and over? If so, you’ll be thrilled to hear that you can avoid these time-consuming repetitions.

Create a user-friendly form? Set up the same filter for countless sheets? Generate workbooks and/or worksheets automatically? You’ll learn it all in our ‘Excel: VBA Programming’ training.

In this (technical) training, you’ll learn how to automate your work in Excel using Office’s programming language (Visual Basic for Applications). You’ll never have to waste time on repetitive actions again and you’ll be able to spend more time on other tasks. Can you be any more productive?

Objectives

After this training, you’ll be able to develop your own applications in Excel Visual Basic for Applications (VBA).

Target Group

Everyone who carries out the same action in Excel regularly and would benefit from automating it.

Prerequisites

You don’t need any experience with VBA, but decent Excel knowledge is required. This means you need to be familiar with the following terms: PivotTables, conditional formatting, data validation, tables, charts, slicers, etc. Good analytical insight is a plus as well.

Content

Part 1 Macros

  • Saving a macro
  • Linking a macro to a button
  • What can a macro not do?

Part 2 Basic principles of VBA and Programming

  • Visual Basic Editor (Project window, Code window, Properties window)
  • What are modules?
  • Variables (Declaration, Scope, Data types)
  • Routines (Difference between sub and function; Writing your own functions)
  • Decision structures (If then else; Select case)
  • Loops (for next, do loop while, do loop until, do while loop, do until loop)
  • Showing message boxes to the end user
  • Error handling

Part 3 Using Excel objects in your code

  • What is an object?
  • Properties, methods (actions), and events of an object
  • Application (Changing Excel application properties via code)
  • Workbook(s) (Opening/creating/saving/closing workbooks via code)
  • Worksheet(s) (Add, delete, copy worksheets… via code)
  • Range (Copying cells, reading data from Excel, deleting data…)
  • Listobjects (Creating tables, going through the rows/columns of tables…)
  • Miscellaneous (PivotTables, Charts…)

Part 4 Developing Forms

  • Working with Form Objects ((Buttons, List Boxes, Check Marks…)
  • Creating your own form (accessing a form, placing objects on a form (textbox, combobox, buttons….) and programming them)
View all our trainings

Request a quote

"*" indicates required fields

Address*
Name*
In which language(s) do you wish to organise this training?
You apply for this course as:
Do you want the training online or on-site?