In this tutorial we will be creating the simple stopwatch & countdown timer shown below.
Firstly we insert three images that we will use as the start, pause & reset buttons. They can be any image you like, it really doesn't matter.
When you have chosen/downloaded your images, save them to a location on your device. Feel free to use mine.
On the Menu bar Click Insert then Pictures, hover over and click "This Device" and browse to the location where your images have been saved. Select an image and click insert.
Your image will be inserted onto your spreadsheet as below.
Repeat these steps until you have all the images you require on your sheet, resize them so that they are the size required and position them as shown below.
Select Cells B8 : D9, Select "Merge & Center", and add a thick outside border. The colour of your choice.
Now we will change the format of the merged cell to the "Time" format. With the cell selected press the "Ctrl" & "1" keys together and the format options window will appear. Select the "Time" category on the left, and the type shown below. Then click OK and it will appear as shown below.
We will now enter the value "00:00:00" into the merged cell, and change the format of the cell so that it is centre aligned both vertically & horizontally and the font is "Impact" and size "26".
We will also select & merge cells B2 : D2 and add the title "TIMER", formatting it so that it is centre aligned both vertically & horizontally and the font is "ARIAL BOLD" and size "14". All should now appear as shown below.
Now, to do the same for the countdown timer we shall simply select cells A1 : E10, and copy and paste them into cell A14. Select the title in cell B15 and change it to "COUNTDOWN", Select the time in cellB21 and change it to "00:15:00" to show a 15 minute time to count down from and all should now appear as shown below.
Now we will add the VBA code that will operate the stopwatch and countdown timers into two modules in the workbook. For each there will be three pieces of code or "Sub Procedures". One for each button, as we will be using the button images as buttons to execute our code.
To do this for the stopwatch follow the steps below:-
Just as you did with the Module1 above, insert a new module which will by default be named Module2 & paste the following code into the window that opens and again hit save.
The VB Editor window should now appear as below. Now hit save.
We now need to make the buttons work! We can do this by assigning one of the Macro Sub Procedures we have to each one.
Minimise the VB editor window so that you can see the workbook again, and right click on the timer's start button. Hover over the menu that appears and select "Assign Macro". The following window will appear. from this window select "StartTimer" and click Ok.
That's it, all done! Now test your stopwatch and countdown timer to see how they work.
Save the file with whatever name you see fit, and with a file extension of "XLSM" (Macro Enabled Excel File). We have called the file Timers.XLSM