Can I Start a Countdown Timer after URL is Clicked

[Bkewlbro]

Hello all,
First post here! Okay I know what i want done but don't know if it is even possible! First off I'm a total scrub at excel... Sure you hear this alot! I'm looking for a way that when I click an Url, a timer preset to a given time automatically, without pushing a button. Now like I said I'm a noob and pretty much just know how to make an invoice lol. I'm a fast learner if this can be done. I've looked all over google with no luck...


B3 = Full Wait Time | C3 = CountDown Timer | D3 = Url
B4 = Full Wait Time | C4 = CountDown Timer | D4 = Url
B5 = Full Wait Time | C5 = CountDown Timer | D5 = Url
So On So Forth...


Any links or ideas on how i can complete this would be awesome. I know how to add a button but really don't want one. I have a handful of urls that need different times and this would make my rotations of this sites so much easier! The only ting i could think of from what I read would be "SelectionChange". So When I click the next link the countdown timer for the url clicked before. But anywho thank you for any ideas or anything else!

[spitfireblue]

Hi,

I don't really understand what you are wanting with the timer section, but you can start a macro running when you select a hyperlink by using:

Please Login or Register  to view this content.

[Bkewlbro]

C3 = CountDown Timer | D3 = Url

Would this code start countdown timer in "C3", when Url is clicked in "D3"? Sorry if it's a stupid question, but really have no clue. By any chance could you provide a link or explaining it more in depth, so i can get a fuller understanding.

[spitfireblue]

Hi,

The code that I previously sent was just the code needed to start a macro when a hyperlink was clicked.
Here is the code you need to create a countdown timer as well.
I have attached an example for you as well.

Please Login or Register  to view this content.

Book1.xlsm

[Bkewlbro]

thats the nail on the head thank you so much!!! My hero!

[lahaine]

So it happened that he and I needed this form in the table, Thank you very much.
How to add, for example 20 links and each timer works separately ? And another question - When the timer reaches the 00:00 - to change FILL color on red ?

Thanks in advance.