Need help with timer/stopwatch...how to change activex button color...how to reset form

As my stopwatch/timer currently stands the activex “Start” button is gray. I would like to change the color to green. I have tried the following code “CommandButton1.BackColor = 12713921” but I am getting error messages. Can someone please show me how to insert this code so the Start button will be green? I still want the “Stop” button to flash between green and red.

Also, when I want to start a new set of numbers I delete the current numbers but when I click the start button the new time data starts where the old time data left off. Is it possible for the code to have the new time data start back in cells b3 and b4?

I have attached the worksheet.

Thank you in advance for any help,
yeto

Originally Posted by AlphaFrog

Please Login or Register  to view this content.

Please Login or Register  to view this content.

If you want to start a new set of numbers, delete the rows in the table. Don't just clear them.

Thank you for taking time out of your day to reply. This worked perfectly.

Kind regards,
yeto

Originally Posted by torachan

Alternative, Stop/Start buttons same position, enabled/disabled, flashing control by wait timer in module.

Thank you for taking time to provide the code. This gives me some ideas as to how I can make the stopwatch even better to suit my needs.

Kind regards,
yeto