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
    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!