+ Reply to Thread
Results 1 to 34 of 34

create a chronometer on excel

Hybrid View

  1. #1
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,469

    Re: create a chronometer on excel

    .
    In the mTimer3 module :

    
    Private Sub Chrono()
    Dim T As Double
        T = TimeValue(UserForm3.LblTemps.Caption) - TimeSerial(0, 0, 1)
        UserForm3.LblTemps.Caption = Format(T, "hh:mm:ss")
        If T = 0 Then TimerOff
    
    '///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
    'As an alternative you could try making a call to a separate Sub with the sound command/s, instead of placing the code here.   
     
        If UserForm3.LblTemps.Caption = "00:59:55" Then '<--- set the time for sound here
            Beep  '<-- place your command here for sound
        End If
    '\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
    
    End Sub

  2. #2
    Registered User
    Join Date
    12-03-2017
    Location
    FRANCE
    MS-Off Ver
    2017
    Posts
    12

    Re: create a chronometer on excel

    What happens with the module3?

  3. #3
    Registered User
    Join Date
    12-03-2017
    Location
    FRANCE
    MS-Off Ver
    2017
    Posts
    12

    Re: create a chronometer on excel

    sorry I did not see the rest of the message...

  4. #4
    Registered User
    Join Date
    12-03-2017
    Location
    FRANCE
    MS-Off Ver
    2017
    Posts
    12

    Re: create a chronometer on excel

    Hmm, when I insert the code, nothing happens.I am really bad. How do I insert the code into the file?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Countdown Chronometer
    By score in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-28-2017, 07:15 PM
  2. How to create an Stopwatch (chronometer) using two buttons.
    By DiogoamCoutinho in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 09-28-2015, 10:40 AM
  3. Create a function to create a new excel file
    By srbelle in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-26-2015, 07:04 AM
  4. Replies: 7
    Last Post: 09-29-2014, 09:24 AM
  5. Replies: 3
    Last Post: 06-27-2012, 02:25 PM
  6. Replies: 3
    Last Post: 09-30-2011, 04:35 AM
  7. Replies: 2
    Last Post: 08-18-2006, 07:20 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