Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #11  
Old 09-16-2018, 12:58 PM
Logit Logit is offline 10 Second Timer for Calling Bingo Windows 10 10 Second Timer for Calling Bingo Office 2007
Expert
 
Join Date: Jan 2017
Posts: 591
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

.
This version should answer all your questions :

Code:
Option Explicit

Sub starttimer()
On Error Resume Next
    Application.OnTime Now + TimeValue("00:00:01"), "nexttick"
End Sub

Sub nexttick()
On Error Resume Next
    If Sheet1.Range("S9") = 0 Then
        Sheet1.Range("S9").Value = "0:0:10"
        Exit Sub
    End If
    Sheet1.Range("S9").Value = Sheet1.Range("S9").Value - TimeValue("00:00:01")
    starttimer
End Sub

Sub resettimer()
    Sheet1.Range("S9").Value = "0:0:10"
End Sub
Sub stoptimer()
On Error Resume Next
    Application.OnTime Now + TimeValue("00:00:01"), "nexttick", , False
End Sub
Attached Files
File Type: xlsm EXCEL BINGO PROGRAM Sep 5 20181.xlsm (30.4 KB, 14 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
#REF Error when calling VBA Function RodneyJ Excel Programming 1 01-21-2016 12:42 PM
Re-Calling Sent Email freschij Outlook 1 12-06-2010 09:16 PM
calling images with a button sammer021486 PowerPoint 0 01-13-2010 08:24 AM
10 Second Timer for Calling Bingo first timer papamadre Forum Support 1 10-24-2009 06:26 AM
Bingo Cards office_mike Excel 1 11-29-2008 10:17 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:39 AM.


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