Results 1 to 2 of 2

Stuck with having a vba only apply to a specific slide

Threaded View

  1. #1
    Registered User
    Join Date
    06-03-2022
    Location
    London
    MS-Off Ver
    10
    Posts
    1

    Stuck with having a vba only apply to a specific slide

    Sorry a complete noob to vba but I'm using a vba to create a countdown timer, here it is:

    Sub countdown()
    
    Dim future As Date
    
    future = DateAdd("n", 30, Now())
    
    Do Until future < Now()
    
    DoEvents
    
    ActivePresentation.Slides(21).Shapes("square").TextFrame.TextRange = Format(future - Now(), "nn:ss")
    
    Loop
    
    End Sub
    Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

    Question:

    This creates a countdown timer in the shape named "square" on slide 21 (in bold for ease). The problem is sometimes I change the order of the slides so have to respecify the slide each time, is there a way to have this run without needing to specify the slide? I've tried googling this and apparently the trick is to remove the 21 but this doesn't seem to work. Anyone know how to do this? Thanks in advance.
    Last edited by 6StringJazzer; 06-03-2022 at 05:47 PM. Reason: added code tags; moved from Excel Programming / VBA / Macros

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Show specific PowerPoint slide from Excel (based on header text)
    By NewBee_HS in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-09-2022, 09:32 AM
  2. Replies: 6
    Last Post: 07-09-2021, 04:17 PM
  3. Replies: 0
    Last Post: 07-18-2019, 07:43 AM
  4. Replies: 1
    Last Post: 07-28-2017, 07:20 AM
  5. Inserting Slides from Another Presentation Removes Slide Numbering & Footer on Slide
    By PSSMargaret in forum PowerPoint Formatting & General
    Replies: 2
    Last Post: 05-15-2016, 09:21 AM
  6. Replies: 1
    Last Post: 04-02-2012, 03:57 PM
  7. Selecting specific slide using vba
    By thedreamshaper in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-01-2011, 11:38 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1