Project: VBA Programming

  • Course types: In company
  • Duration: 2 days

We recommend that you sign up for both the basic and advanced Project courses before enrolling for the VBA course below.

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

Request an offer



Share this course on Facebook, Twitter, LinkedIn or e-mail

Requesting a quotation

Would you like to organize this training course for your employees? At your offices or at a Xylos training centre? We transform your requirements into the perfect solution.

Request

Questions?

Contact Inès Vansteenkiste

+32 2 264 13 20
xylos@xylos.com