I have assigned macros to each of them.As you can guess, each of these spots correspond to one time zone, from PST to Australian Time.I have named these hotspots spot1, spot2…,spot9.On top of this I have added 9 hotspots by drawing nine circles.
I took an outline map of world and put it in an empty sheet.Now, the basic construction of this workbook can be broken down to 3 parts: The current time is fetched from your computer’s local time using NOW() formula.
How does the Count-down Timer Work?įirst, I must tell you about its limitations: PS: You must drag and drop this file in to Excel 2007 or above to see it.
Here is a video demo of how the VBA application works ( watch on YouTube):ĭownload the VBA Classes Count-down Timer Workbook:Ĭlick here to download the workbook. Then it struck me, why not make an Excel workbook to tell you how much time you have got? So I did just that. I was thinking of ways to tell you that you have got less than 3 days to join our VBA Class. So I will give you a few seconds before reading further. Here is a cool count-down timer application made in VBA to remind you about our VBAClasses registration closing time!