Live Webinar – September 15th, 2021 12:00 pm – 1:30 pm EDT
Activity Type: Education – Course or Training  1 Hour  1 PDU
Provider: MPUG WebnLearn ( REP 1369 )
Mpug Member Free – Members only event

Ira Brown will deliver this fun and informative three-part series that will provide you with an in-depth understanding of the automation capabilities of Microsoft Project.

The session is geared toward a Microsoft Project business user and will provide practical, real-world illustrations for solving common challenges a user faces with Microsoft Project.

The initial session will provide an overview of working within the VBA environment, including the basics of recording and editing VBA macros. We will produce several useful macros together, and also learn how to assign a macro to a custom ribbon button.

Once Ira has covered the fundamentals, he will demonstrate how to use VBA to create custom, user-friendly forms as a front end for your VBA functionality.

In the final session of this series, you will learn how to use VBA to integrate Microsoft Project with other Microsoft Office applications, including Word and Excel.

Learning Objectives:

Part 1: Working with Macros and VBA Fundamentals

• Ability to create basic VBA macros
• Ability to edit VBA macros
• Proficiency in assigning a macro button to a custom ribbon

Part 2: Using VBA Forms to Create a Custom User Interface

• Introduction to building a user-friendly interface for your VBA functionality
• Ability to create a custom VBA form
• Ability to launch your VBA form from a ribbon button

Part 3: Using VBA to Integrate Microsoft Project with other Microsoft applications

• Using VBA to integrate Microsoft Project with Excel
• Using VBA to integrate Microsoft Project with Word
• Using VBA to integrate Microsoft Project with PowerPoint

Presenter: Ira Brown (LinkedIn profile) is the President and CEO of Project Widgets, a Microsoft Project Partner specializing in add-on products, implementation services, integration, training, and custom software development for Microsoft Project. He is a is a recognized Microsoft Project expert with 20+ years of experience.

Project Widgets is well-known for offering add-on products for Microsoft Project and Project Online, as well as for creating custom solutions that meet their clients’ unique business requirements. Project Widgets even have several free, downloadable widgets available on their website that you can begin using right away

If you are NOT ALREADY a member JOIN MPUG!

This event is for members only BUT… You can take one of the MPUG Certificated Masterclass (Usually 6 Category A PDUs) Or over 30 other Category A PDUs for free each year.  The $129 Per Year Membership Fee is a terrific value!

MPUG Membership includes:

1. MPUG’s Project Server and SharePoint certificated courses available to members
2. Over 30 other virtual PDU events per year
3. You can network with other MPUG (Microsoft Project Users Group) members at in person meetings and events.
4. Work with Microsoft MVPs in MS Project Project Server & SharePoint
5. And so much more …

Seriously consider joining MPUG if you work with SharePoint or Project & earn all the PDUs you will need as a member of MPUG!

Click to register for:
Exploring VBA: Microsoft Project’s Macro Language

NOTE: For PMI® Audit Purposes – Print Out This Post!  Take notes on this page during the presentation and also indicate the Date & Time you attended. Note any information from the presentation you found useful to your professional development and place it in your audit folder.