Subscribe to Indezine
Follow Indezine

Follow Indezine on Pinterest
Share This Page
Bookmark and Share
Translate Page

Like This Page
Like This Site

Product Showcase

PowerPoint Programming

Everything about PowerPoint programming including VBA, VSTO, and more.

Friday, March 20, 2009
posted by Geetesh at Friday, March 20, 2009 IST

Note: If you don't know how to use macro snippets or scripts inside PowerPoint, look here...

This started with my Create Spirograph in PowerPoint tutorial -- and thanks to my friend Shyam Pillai who said I could do that so much faster programattically by using this code:

Sub CreateSpirograph()
Dim oShp As Shape
Dim I As Single

Const ROTATION_INCREMENT = 5 'Rotation Increment
Const ROTATION_MAX = 360 'Max rotation

'Select a shape on the slide and then run this
Set oShp = ActiveWindow.Selection.ShapeRange(1)

With oShp.Duplicate
.Rotation = I
.Left = oShp.Left
.Top = oShp.Top
End With
End Sub

Remember you need to have some shape selected before you run this code. Also, Shyam adds that you can change the ROTATION_INCREMENT and ROTATION_MAX values to get different graphs.

Shyam Pillai is a Microsoft PowerPoint MVP, visit his site for many VBA snippets, free and commercial PowerPoint add-ins

Labels: , , , ,


Links to this post


Post a Comment

Links to this post:

Create a Link

    follow me on Twitter


    March 2009  |  April 2009  |  April 2010  |  

    Featured Story

    Concept Slides: Segment Triangle

    Geetesh BajajWe start this issue with an unconventional approach to no-bullets presentations – let’s give you a hint, a conversation replaces the bullets. We then provide you with an amazing seven segment circle graphic that’s completely PowerPoint ready – just copy and drop it in your next presentation to edit, modify, and play with. Did you know about the lengths that people would go to – just so that they are in proximity to their iPads? Learn more about that too! Then you get to read how you can create better slides for a PechaKucha or Ignite presentation. And then there's a review of a large collection of PowerPoint charts and diagrams. Have fun reading this issue and share your thoughts with us!

    Read the newsletter here.

    Featured Book

    PowerPoint 2007 Complete Makeover Kit

    PowerPoint 2007 Complete Makeover Kit
    PowerPoint 2007 Complete Makeover Kit is out! Check the book on

    And here are some free excerpts...

    Home | PowerPoint | Photoshop | Free PowerPoint Templates | PowerPoint Tutorials | Blog | Notes | Ezine | Offers | Advertise | Feedback | Site Map | About Us | Contact Us
    Link to Us | Privacy | Testimonials
    Free PowerPoint Backgrounds | Free Christian PowerPoint Backgrounds | Free Business PowerPoint Presentation Templates

    Plagiarism will be detected by Copyscape

      ©2000-2013, Geetesh Bajaj. All rights reserved.

        since November 02, 2000