Skip to main content

Project: VBA Programming

Version: Microsoft 365
Duration: 2 days (09:00-17:00)
Price incompany training: € 2750 excl. VAT excl. / Terms for incompany training.

Request a quote

Description

Visual Basic for Applications, the Microsoft Office programming language, allows you to carry out several operations at once in Microsoft Project, with just one press of a button. It also allows you to create any missing program features yourself. VBA gives you faster results and helps you to create more professional project schedules.

Objectives

After the Microsoft Project VBA course, you will be able to create, edit, use and manage modules that contain macros.

Target Group

This course is designed for professional users who regularly create schedules with Microsoft Project and who wish to automate operations and add new functionality to Microsoft Project.

Prerequisites

Participants have worked for some time with Microsoft Project at an advanced level. It is therefore advisable to have completed both the basic and advanced Microsoft Project course. Knowledge of and/or experience with VBA in Microsoft Office is not required.

Content

Introduction to macros

  • Introducing the “Developers” ribbon
  • Customizing security

A simple start

  • Recording a macro
  • Recording actions
  • Viewing and editing macros
  • Displaying and managing macros
  • Managing modules with the Organizer

Creating and using a toolbar with macro buttons

  • Adding macros to the “Quick Access” toolbar
  • Creating a ribbon for macro buttons
  • Adding, grouping and using buttons

Working with the Visual Basic Editor

  • Layout of the window
  • Introduction to VBA projects
  • Creating and editing a VBA module
  • Creating and editing VBA procedures
  • Object-oriented programming
  • Expanding object collections with VBA
  • Customizing objects using VBA
  • VBA methods and their parameters
  • Adding and using VBA features

Creating specific Microsoft Project macros

  • Inserting a data column in the input table
  • Hiding a data column in the input table
  • Filling an empty column with calculated task data
  • Filling an empty column with combined task data
  • Quickly replacing resource names with resource initials and vice versa in the Gantt Chart
  • Undoing macro actions simultaneously
  • Testing the current version of Microsoft Project
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?