VBA – Basic Course

VBA – Basic Course

Course overview

The course teaches you how to automate your work and connect Office programs with Visual Basic for Applications (VBA).

You will learn how to get the programs in Microsoft Office to work together and to retrieve and use information from external data sources. Automating routine tasks with VBA often saves you a lot of time and reduces the risk of errors. The examples in the course are based on Excel.

See also our courses in user programs such as Excel, Power BI and other productivity tools.

Course Objective

After the course, you can:

  • Record, run, and edit macros in Visual Basic Editor
  • Link code to buttons, menus, and events
  • Using variables, constants, and data types
  • Create procedures and functions
  • Control code flow with conditions and loops
  • Working with objects, methods, and properties
  • Create dialog boxes and forms
  • Communicate with other Office programs
  • Troubleshoot and handle errors in VBA code

Target Group

The course is aimed at those who:

  • Want to automate work and connect programs in Microsoft Office with VBA
  • Want to retrieve and use information from external data sources in Office

Prerequisites

You should have good experience with Microsoft Office, especially Excel and Word. Some programming experience is an advantage.

Certification

This course does not have any associated certification. Each participant who completes the course receives a course certificate.

Trainer

The course is conducted in collaboration with one of Informator’s partners.

More about the course

Course content

Introduction

  • Different types of macros
  • Areas of use

Introduction to VBA

  • Record and run macros
  • View and edit macros
  • Visual Basic Editor

Usability

  • Linking code to buttons and menus
  • Link code to events, such as highlighting and clicking
  • Create and customize menus

Dialog boxes

  • Create dialog boxes
  • The toolbox
  • Events

Variables and constants

  • Different types of variables
  • Data types
  • constants
  • Get the host
  • MsgBox and InputBox

Procedures and features

  • Create and use procedures and functions
  • Modules
  • Sub-procedures
  • Function procedures

Control the flow in VBA code

  • Select Case
  • For–Next
  • For Each–Next

Object orientation

  • What is an object?
  • Object classes
  • Methods and characteristics
  • The object reader

Forms

  • Create forms
  • Checks in forms

Communication with other programs

  • Communicate with other Office programs

Error handling and troubleshooting

  • Field types
  • Direct window
  • Troubleshooting and Breakpoints
  • Error handling and compilation

Course overview

14500 kr

2 days

Basic

Can’t find a (suitable) date, but are interested in the course? Send in an expression of interest and we will do what we can to get an opportunity that suits.

För samtliga utbildningar gäller våra
Allmänna Villkor.

Company-adapted course

The course can be adapted from several perspectives:
  • Content and focus area
  • Scope of application
  • Structure

In collaboration with the course leader, we make sure that the course meets your wishes

Expression of interest