


Sometimes you may want to change the text and make it fancy.
How to make text into two columns in powerpoint how to#
You might already know that you can format any text in PowerPoint, but did you know that you can also use WordArt in your PowerPoint presentation? Find out in this article how to change text to WordArt, insert columns and hyperlinks as well as how to apply formatting and styles. But maybe this time you would like your presentation to look a bit different. If the subtitle is not the second placeholder, you will need to find it's item number (index) in the placeholders collection in the custom layout you are using.The easiest way to make a presentation is to do it with PowerPoint. So long as the slide is created with a custom layout with the subtitle as the second placeholder, you can use something like this: (2). = DataRow.Cells(1, 2) I know that is a lot to read but it may help explain this answer: Placeholders collection is a subset of the shapes that are placeholders from the slide's layout. Shapes collection is all Shapes on the slide. Shape.Title property (PowerPoint) documentation says:Īs that implies there are two Collections on each Slide.

The Title property of the Slide can be thought of as a reference to a specific shape on the slide. The shape that holds the slide's title text is a special case. I'm glad you were able to follow along with the example. You can adjust and modify as required but that is the basic idea. The complete routine looks like this: Sub LoopRowsSelected() This will add a new slide based on the second custom layout of the master slide in the currently open copy of PowerPoint. Within the loop add the following: Set Sld = ( + 1, (2)) You can create a new slide and set the title to the value of the that cell. Let's assume you want to create a slide for each row of your selection and, you want to set the Title to the text in the first column of your selection. Loop through the range and create a slide for each This assumes PowerPoint is open with a presentation file active. Set AppPPT = GetObject(, "PowerPoint.Application") With that reference added, you can use PowerPoint's Objects from your Excel Module. To access PowerPoint from Excel, add a reference to its object libraryįrom Tools on the Command Bar select Referencesįrom the list of libraries select the one for PowerPoint Again, you can use any other method appropriate to your task.Ĭreate a reference to PowerPoint and the current presentation This assumes there is a selection of cells on a worksheet. Here a simple one that uses the current selection Sub LoopRowsSelected()
