Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Microsoft PowerPoint _ Using Vba To Loop Through Certain Slides Until A Certain Time

Posted by: Psycoperl Nov 20 2019, 04:42 PM

I am wondering if PowerPoint and VBA could be used to loop through a set of introductory slides (welcome messages) until a certain time which then it would advance to the next slide.
i.e. I would like to have slides 1-4 to rotate through on a loop until it gets to 1PM (where then the next set of slides will go on.)Thanks in advance for any thoughts and guidance.

Posted by: ngins Nov 21 2019, 03:25 AM

Not sure if you're asking about a delay with each slide, or if you're asking about how to stop slides 1-4 from looping at 1 PM.

To do the latter, you would do this:

    {stuff to show slides}
Loop Until Now() >= #1:00 PM#

If you want each slide to show for, say, 15 seconds, then it would be something like this:

Dim dt as Date

dt = DateAdd("s", 15, Now())
{show slide}
Loop Until Now() >= dt

Posted by: Psycoperl Nov 21 2019, 04:13 AM

For example we open doors at 12noon the “walk-in” slides (1-4) would be on a loop
At 1pm we want to move to the rest of the ppt automatically

Posted by: ngins Nov 21 2019, 04:51 AM

OK, I'm not familiar with powerpoint coding. I was just giving your the code for creating a loop in VBA.