We Value Your Privacy

We and our partners use technology such as cookies on our site to personalise content and ads, provide social media features, and analyse our traffic. Click below to consent to the use of this technology across the web. You can change your mind and change your consent choices at anytime by returning to this site.

Update Consent
Loading ...

How to Insert a Countdown Timer in an Excel Worksheet

Updated February 21, 2017

A countdown timer in an Excel spreadsheet could be helpful on a time-sensitive sheet, allowing the user to keep track of how much time they have left before a given event or deadline. While Excel doesn't have a countdown function or feature, you can use the built-in Visual Basic for Applications (VBA) programming language to create a countdown in a single Excel cell.

Loading ...
  1. Open the Excel 2010 worksheet where you want to add a countdown timer. Right-click the cell where you want the timer to go and choose "Format Cells." Click "Custom" on the left side of the window that appears and then select "h:mm:ss" from the list on the right. Click "OK" to continue.

  2. Hold down "Alt" and press "F11" to open up the VBA console. Select your current worksheet from the list on the left side of the console. Click the small arrow next to the "Insert Userform" button at the top of the screen, which is the second button from the left side, and choose "Module" from the list of options that appear. Double-click "Module 1" when it appears in the list.

  3. Click the white space on the right side of the screen and enter the following code:

  4. Sub Countup()

  5. End Sub

  6. This code will allow the rest of the code to process once each second.

  7. Press enter to access a new line on the page. Enter to following code:

  8. Sub Realcount()

  9. End Sub

  10. Change "E1" to whatever cell you want to use for the countdown. This code does the actual countdown and checks to see if the countdown is complete.

  11. Click the "X" in the upper right corner of the console to close it.

  12. Select the cell that you are using for your countdown and enter your desired countdown time. Be sure that you enter the hours, minutes and seconds, even if the hours and minutes are zero. "2:30" is two hours and thirty minutes; "0:2:30" is two minutes and thirty seconds.

  13. Click the "Developer" tab at the top of the screen, and then click the "Macros" button on the left side of the ribbon. Select "Countup" from the list and click "Run." Your countdown will start and it will continue until it gets to zero, when you will see a message box explaining that the countdown is complete.

  14. Tip

    If you want to make the numerical countdown bigger, you can select a number of cells, as long as your specified cell is in the upper left corner of the selection, and choose "Merge and Center" from the "Home" tab. Then change the font (from the home too), until the numbers are as large as you want them to be.

Loading ...

About the Author

Shawn McClain has spent over 15 years as a journalist covering technology, business, culture and the arts. He has published numerous articles in both national and local publications, and online at various websites. He is currently pursuing his master's degree in journalism at Clarion University.

Loading ...