Results 1 to 6 of 6

Problem adding more countdown timers

Threaded View

  1. #1
    Registered User
    Join Date
    03-04-2014
    Location
    wales
    MS-Off Ver
    Excel 2010
    Posts
    3

    Problem adding more countdown timers

    Hi I work in a school for the exams officer and am trying to create a spreadsheet that can be displayed at the front of the exam hall to advise the students of the start and finish times for the exams as well as having a countdown timer to show them how long they have left.

    The spreadsheet should have the ability to have up to 5 separate examinations with countdown timers running simultaneously. I have created buttons and code for the first exam and could use this countdown timer for any other exams starting at the same time. However, the problem is that the exams do not all start at the same time - for example some of the languages papers are short and run consecutively during a single exam session but need to have individual timers. Also as soon as I type anything else the counter stops which I also do not want to happen.

    I have attached my efforts to date - as you can see there are two sheets a front sheet which is what is displayed and a sheet that contains the examination details used to populate the various fields such as duration. There are three buttons at the end of the first exam Start, Stop and Reset. These all seem to work fine as long as you do not touch the sheet after starting the timer.

    The code I currently have is as follows
    Sub Call_Timer()
     Application.OnTime Now + TimeValue("00:00:01"), "UpdateTimer"
     End Sub
    
     Sub UpdateTimer()
     If ActiveCell.Address = "$B$16" Then
     Range("J15").Value = Range("J15").Value + 1 / 86400
     Call_Timer
     ElseIf ActiveCell.Address = "$B$17" Then
     Exit Sub
     ElseIf ActiveCell.Address = "$B$18" Then
     Range("J15").Value = 0
     End If
     End Sub
    I also have the following on the sheet code
    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
     UpdateTimer
     End Sub
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Best way to make multiple countdown timers
    By Dave_ross in forum Excel General
    Replies: 19
    Last Post: 02-04-2019, 05:06 PM
  2. Multiple Countdown timers.
    By dawidski in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-12-2013, 11:42 PM
  3. How to Create Mutiple Countdown Timers In Excel
    By Janto724 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-26-2013, 06:36 PM
  4. multiple countdown timers in excel?
    By hollandrob81 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-06-2013, 04:12 PM
  5. Countdown Timers?
    By phil2006 in forum Excel General
    Replies: 2
    Last Post: 09-11-2007, 07:00 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