Manipulating Shapes In PowerPoint Using VBA

Поделиться
HTML-код
  • Опубликовано: 14 окт 2024
  • In this video, we will go over how to manipulate and align shapes in a PowerPoint slide using VBA. With VBA, we can set the different dimensions of our shapes within a particular slide and adjust the alignment of the objects.
    Video Resources:
    --------------------------------------------------
    Resource: GitHub File
    Link: github.com/are...
    Resources:
    --------------------------------------------------
    Facebook Page: / codingsigma
    Facebook Group: / sigmacoding
    GitHub Sigma Coding: github.com/are...
    Support Sigma Coding:
    --------------------------------------------------
    Patreon: / sigmacoding
    Amazon Associates: amzn.to/3bsTI5P **
    Related Topics:
    --------------------------------------------------
    Title: Exporting Multiple Excel Charts To PowerPoint Using VBA
    Link: • Exporting Multiple Exc...
    Title: Exporting A Chart From Excel To PowerPoint Using VBA
    Link: • Exporting A Chart From...
    Title: Exporting Multiple Excel Ranges From Excel To PowerPoint Using VBA
    Link: • Exporting Multiple Exc...
    Title: Exporting An Excel Range From Excel To PowerPoint Using VBA
    Link: • Exporting An Excel Ran...
    Title: Manipulating Shapes In PowerPoint Using VBA
    Link: • Manipulating Shapes In...
    Title: Exporting An Excel Table From Excel To PowerPoint Using VBA
    Link: • Exporting An Excel Tab...
    Title: Exporting Multiple Excel Tables From Excel To PowerPoint Using VBA
    Link: • Exporting Multiple Exc...
    Title: Pasting Excel Objects Into PowerPoint Using VBA
    Link: • Pasting Excel Objects ...
    Title: How To Paste Multiple Objects To A Slide in VBA
    Link: • How To Paste Multiple ...
    **Amazon Associates Disclosure:
    --------------------------------------------------
    I am a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com. One of the ways I support the channel is by using Amazon Associates to earn fees on purchases you make. That means when you use the link above, it will track any purchases made from that link and give a small portion of it to the Sigma Coding. I love this approach because it allows you to do what you're already doing (shopping) but also helps support the channels you care about. Also, it makes it where I can invest that revenue to help improve and grow the channel.
    Tags:
    --------------------------------------------------
    #PowerPoint #VBA #Shapes

Комментарии • 6

  • @tommarquez1980
    @tommarquez1980 3 года назад +1

    Thanks, I really appreciate your contribution.

  • @ethanprincenthal2715
    @ethanprincenthal2715 4 года назад

    Great video, as always. These have been incredibly helpful throughout my summer internship. Do you know what could cause a shape to be pasted a little below the center of the slide? I am using the msoAlignMiddles and msoAlignCenters method and exporting range arrays (using the method from your export range to PPT video). Thanks for the super helpful videos

  • @MohaMed-AdeL1
    @MohaMed-AdeL1 2 года назад

    good work but bad resolution need high resolution to just read code

  • @61814fahad
    @61814fahad 4 года назад

    very helpful tutorial .But i have a problem with my shape . I am struggling to set a perfect rotation so that it shows like i perpendicular line object.my code for the rotation of line object is given below. can you please review it and give me a solution.
    Sub AddStraitLine()
    With PPApp.ActivePresentation.Slides(1).Shapes.AddLine(BeginX:=2.78 * Inch, BeginY:=3.44 * Inch, _
    EndX:=5.72 * Inch, EndY:=5.84 * Inch).Line
    .DashStyle = msoLineSolid
    .ForeColor.RGB = RGB(186, 184, 184)
    .Visible = msoTrue
    .Transparency = 0.5

    End With
    PPApp.ActivePresentation.Slides(1).Shapes(4).ThreeD _
    .RotationX = 0
    End Sub
    Thanks in advance.

  • @sagargondage6266
    @sagargondage6266 3 года назад

    How can enter text box?