Lifelong learning for working professionals

VBA – Basic Course

Course overview

The training is aimed at those who want to learn how to connect different programs for more efficient work with the help of Visual Basic for Applications (VBA).

We’ll show you how to get MS Office applications to work together, and how to retrieve and use information from external data sources. Developing applications for MS Office often means large time savings and reduced risk of errors as routine work steps are automated.

Examples in the course are based on Excel.

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

Datum

Plats

Språk

Clear

Course Objective

After the course, you can:

Building a Good Foundation in VBA Programming

Target Group

The training is aimed at those who want to learn how to connect different programs for more efficient work using Visual Basic for Applications (VBA), or who want to retrieve and use information from external data sources in Microsoft Office.

Prerequisites

Programming experience and extensive experience working in MS Office, mainly Word and Excel.

Certification

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

Trainer

We have several competent trainers for this course.

More about the course

1. introduction

Different types of macro
Areas of use

2. Introduction to VBA

Record and run VBA macros with the recorder
Viewing and editing VBA macros
Visual Basic Editor

3. usability

Linking code to buttons and menus
Link code to events; select, deselect, click, etc.
Create your own and customize menus

4. dialog boxes

Create dialog boxes
The toolbox
Events

5. Variables and constants

Different variables
Data types
Enter constants
Get the host
MsgBox
InputBox

6. procedures and functions

Create and use procedures/functions
Modules
Create procedures Sub
Create functions Function

7. several ways to control VBA code

Select-Case
For-Next
For-Each-Next

8. Object orientation

What is an object?
Object classes
Methods and characteristics
Property inspector

9. forms

Create forms
Checks in forms

10. communication with other programs

Communicate with other Office programs

11. error handling and troubleshooting

Field types
Direct window
Troubleshooting
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