Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-08-2015, 02:26 AM
JohnWilson JohnWilson is offline Macros to select random odd numbered slide Windows 7 64bit Macros to select random odd numbered slide Office 2010 32bit
Programmer
 
Join Date: Nov 2008
Location: UK
Posts: 1,914
JohnWilson has a spectacular aura aboutJohnWilson has a spectacular aura about
Default

Maybe something based on:

Sub getNext()
Dim lngCount As Long
Dim lngOddslides As Long
Static rayOdd() As Long
Dim L As Long
Dim x As Integer
Dim nextSld As Long
lngCount = ActivePresentation.Slides.Count
lngOddslides = lngCount \ 2 + lngCount Mod 2
On Error Resume Next
Err.Clear
If UBound(rayOdd) < 1 Or rayOdd(1) = 0 Then
ReDim rayOdd(1 To lngOddslides)
For L = 1 To lngCount Step 2
x = x + 1
rayOdd(x) = L
Next L
End If
nextSld = Int(Rnd * (UBound(rayOdd))) + 1
SlideShowWindows(1).View.GotoSlide rayOdd(nextSld)
rayOdd(nextSld) = rayOdd(UBound(rayOdd))
If UBound(rayOdd) > 1 Then
ReDim Preserve rayOdd(1 To UBound(rayOdd) - 1)


Else: ReDim rayOdd(1 To 1)
End If
End Sub
__________________
Microsoft PowerPoint MVP 2007-2023
Free Advanced PowerPoint Tips and Tutorials
Reply With Quote
Reply

Tags
macros



Similar Threads
Thread Thread Starter Forum Replies Last Post
Word Mixing Numbered Headings with Numbered List Tess0 Word 11 07-15-2014 05:25 AM
Macros to select random odd numbered slide Lyric slide show - using a variable to pull text from next slide elfman12 PowerPoint 3 03-08-2013 12:27 AM
Macros to select random odd numbered slide Text typed on slide x ports to slide y automatically? Thinker PowerPoint 5 07-26-2012 11:59 PM
Macros to select random odd numbered slide Create PPT slide presentation with Excel data. Chart is displayed off the slide. eratem PowerPoint 4 02-29-2012 09:44 AM
PP 07 Random Chart Dissappearing in Slide Show DKY PowerPoint 0 11-02-2011 04:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:20 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft