All posts by Pedrum

No Thumbnail

Change Presentation ColorScheme(VBA for PowerPoint)

In this article I will explain how you can change the color scheme of a presentation using VBA for PowerPoint. Basically each presentation has one or more slidemasters. Slides that come after each slidemaster will inherit the properties of the slidemaster. By changing the theme

No Thumbnail

Create a Presentation in PowerPoint using VBA

The presentation object is the main object used in VBA for PowerPoint. If you are familiar with VBA for Excel, you can consider the Presentation object as the Workbook of the project. Access A Presentation Object: The presentation objects can be accessed through the Presentations collection: Access

No Thumbnail

Sort A Range of Cells in Excel Using VBA

In this article I will explain how you can use VBA for excel to sort a range of cells. Example 1: Consider the range below. Assume we want to sort the range in ascending order based on column A: The following code will filter based

No Thumbnail

Insert Image in a PowerPoint Presentation Using VBA

In this article I will explain how you can insert an image into a PowerPoint presentation using VBA. The code above inserts the image located in the path “C:\Users\Public\Pictures\Sample Pictures\Desert.jpg” onto slide number “2”. For more information about the parameters to the function please see

No Thumbnail

Excel VBA Pivot Tables

In this article I will explain how you can use VBA for Excel to create pivot tables. Create New Pivot Table: The following code will create an empty pivot table. The function receives as input a source range, and an output range. The source range

No Thumbnail

How to Use VBA to Add Text To PowerPoint Slides

This article explains how you can add text to PowerPoint slides using VBA. Note unlike MS Word where you can add text anywhere in the document, in PowerPoint you can only add text inside text boxes. This is regardless of whether you are using VBA