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 a quote
"*" indicates required fields
