' PowerPoint VBA Macro to run a slide show in a random order. The comments in green tell you what each part of the macro is doing. The full VBA (Visual Basic for Applications) macro is included below and if you need to know how to use it in your presentation then check out our How to use VBA in PowerPoint article. And the really cool bit is that every time the macro is run, you get a different slide order. Finally, the randomised array is used to create a custom slide show that is then set to run. This array of slide IDs is then shuffled like a deck of cards using a randomise function. It gets created when a new slide is added to the presentation and never changes, regardless of where the slide is in the presentation. The next one is the slide ID and this is both unique and constant. But that changes if you move the slide around the presentation. You might not know, but slides in PowerPoint have a couple of identities. It firstly works out how many slides there are in the presentation and creates an array (a bit like a table of data) in which all of the unique slide IDs are stored. So, I opened up the VBE (Visual Basic Editor) built into PowerPoint and wrote a quick VBA macro to do it for me. There’s no native feature in PowerPoint that lets you run your slides in a random order. Jumping from college years to a baby, to an adult, back to a teenager made it more interesting than running in a linear timeline. The completed presentation has one slide for each of my wife’s years, which will get me into a lot of trouble! Playing it back in order was ok but I wanted to mix it up and have the slides appear in a random order to make it a bit more interesting. It was an obvious choice to use PowerPoint to design the content. But pictures weren’t enough, I wanted them to be ‘presented’ with an attractive design, a timeline indicator and captions. I recently organised a birthday party for my wife and, as I have a high-quality projector mounted on the ceiling, I thought it would be cool to have a slide show of pictures from across the years playing on the wall. I love PowerPoint even more when I can get inside it and use VBA code to make it do stuff most people don’t even know is possible. I use it to create all sorts of things from the obvious presentations, to print documents, videos and even animated GIF images. There, I said it and I feel better as a result, just as my therapist told me I would. When everything we do here at BrightCarbon is about telling your stories more effectively with a logical and linear flow it might seem like a very strange thing to want to do. Viewing your PowerPoint slide show in a completely random order. If you want to keep up with the latest versions of Bingo Caller, sign up to our free mailing list and we’ll let you know when we release a new version.Now here’s a curious concept. SAPI is already part of your Windows installation. If you are running Windows Vista or Windows 7 then you don’t need these downloads. SAPI Install for Windows 98/Me/2000 – 6.2MB To enable speech support, if you don’t already have SAPI5 installed, please download one of the following files: Want to know what’s changed, or download older versions? Click here for our change log. Click here to buy one now.ĭownload Bingo Caller v1.38 – Home Licence – 3.8 MBĭownload Bingo Caller v1.38 – Commercial Licence – 3.8 MB Note: You need a licence key to use these programs. Internet connection is recommended to make it easy to register your licence. System Requirements: Windows 98 or higher, 10MB hard disk space, 1024 x 768 screen resolution or higher recommended. When you decide Bingo Caller is right for you, you need to download the full version below and purchase a licence key. Other than this, the download is identical to the full version of Bingo Caller. You can re-load the program and draw another 15 numbers, but you can only draw 15 in one session. The limitation of this version is that you can only draw 15 numbers before the program stops working. System Requirements: Windows 98 or higher, 10MB hard disk space, 1024 x 768 screen resolution or higher recommended.īingo Caller is available in a free evaluation version.
0 Comments
Leave a Reply. |