Countdown timer beep under 10 seconds.

  • I have created a timer in excel. I would like it to beep every second under ten seconds. I have tried the follow method but the beep is happening every second instead of only playing under ten seconds.


    VBA module:
    Function BeepMe() As String
    Beep
    BeepMe = ""
    End Function

    In Sheet2 Cell B2 I have my timer 12:01:30 AM formatted to display mm:ss


    in cell c2 I have this function =IF(B2<"12:00:10",BeepMe()."")


    Please advise how to only play the beep under 10 seconds.


    Thank you

  • assuming you have timer in Cell B2 running the below code will work


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!