How To Update PowerPoint Shapes From Excel Using VBA

304

3 0

Published 2024-01-22

In this video, let's look at how we can update PowerPoint shape colors based on values in an Excel sheet using VBA. Traffic lights are common in monthly and quarterly presentations and updating them manually every month can be a tedious process.

By using VBA, we can automate the process of updating the spreadsheets. We start by getting the name of the shape variables from the selection pane and then updating them with VBA.

All Comments (1)