How can I create a PowerPoint presentation using VBA code?

Creating a PowerPoint presentation using VBA (Visual Basic for Applications) code can be a bit challenging, but it’s definitely possible. Here’s a step-by-step guide on how to accomplish it:

  1. Open Microsoft PowerPoint. Once you have it open, click on the ‘Developer’ tab. If you don’t see a ‘Developer’ tab, you can enable it by clicking on ‘File’, then ‘Options’, followed by ‘Customize Ribbon’ and then checking the ‘Developer’ box.
  2. Start the VBA editor. You can do this by clicking on ‘Visual Basic’ in the ‘Developer’ tab. This will open up the VBA editor window.
  3. Insert a new module. In the VBA editor window, right-click on your PowerPoint project in the ‘Project’ window, hover over ‘Insert’, and click on ‘Module’. This will create a new module where you can write your code.
  4. Write your VBA code. In the new module, you can now write your VBA code. Here’s a basic example of a VBA code that creates a new slide and adds a title and a subtitle:
        Sub CreateSlide()
            ' Declare variables
            Dim ppt As Presentation
            Dim sld As Slide
            Dim shp As Shape
    
            ' Create a new presentation
            Set ppt = Presentations.Add
    
            ' Add a slide with a Title and Content layout
            Set sld = ppt.Slides.Add(Index:=1, Layout:=ppLayoutTitle)
    
            ' Add a title
            Set shp = sld.Shapes.Title
            shp.TextFrame.TextRange.Text = "My Title"
    
            ' Add a subtitle
            Set shp = sld.Shapes.Placeholders(2)
            shp.TextFrame.TextRange.Text = "My Subtitle"
        End Sub
        
  5. Run the VBA code. You can run the VBA code by pressing ‘F5’ or clicking on ‘Run’ in the ‘Run’ menu. This will execute the code and create a new PowerPoint slide with the specified title and subtitle.

Remember to save your work regularly, as VBA doesn’t have an auto-save feature. Also, keep in mind that while VBA can greatly enhance your PowerPoint presentations, it does come with a learning curve. If you need help creating professional PowerPoint presentations, SlideGenius can assist you with design services and more.

View Our Presentation Portfolio

Three overlapping slides are displayed. The first slide reads "American Express Investor Day 20XX." The second slide has "Today's Discussion." The third features a man reading and mentions, "Service is the Core of Our Global Program" and "Custom PowerPoint Presentation Design Support.

Ready to kick off your project?

Fill out the form below to speak
with a SlideGenius representative.