Let me start my question by saying that I am new to VBA. I am using the following (link below) timer/stopwatch excel worksheet which helps me with my job.
I would like to change one thing with the timer/stopwatch in that the button you click to start the timer/stopwatch stays blue when first clicked and the only thing that is different is the text changes from start to stop. I would like for the button when first clicked for the text to not only change to stop but for the button color to change to red and also for the button to blink/flash. I know that a button that blinks/flashes is very annoying but I “NEED” the stop button to be annoying so that I don’t forget to click stop after the task is completed that I am timing. I will be the only one using the spreadsheet so there is no chance it will annoy someone else as I know blinking/flashing is a no-no.
From the research I have done I “think” I would need to delete the current button as it is a “shape” and insert an “activex” button. Unfortunately, I don’t what the next step would be as I can’t find the code to make the button change to red and flash/blink and even if I could find the code I am not exactly sure how to enter the code and link it to the new button. Any help would be greatly appreciated.
Thank you in advance for any help to get me pointed in the right direction,
Sub startStopTimer() If Range("timer.button.label") = "Start" Then Range("time.stamp.start").Offset(Range("count.of.timestamps") + 1).Value = Now Range("timer.button.label") = "Stop" Else Range("time.stamp.start").Offset(Range("count.of.timestamps"), 1).Value = Now - Range("time.stamp.start").Offset(Range("count.of.timestamps")) Range("timer.button.label") = "Start" End If End Sub