Displaying a unique countdown timer with Start/Stop/Reset buttons on multiple lines

[drememagik]

Hello!

I am hoping that you can help me. I am brand new to VBA (as in, I just learned about it yesterday!) but I am trying to develop a spreadsheet that I can use for a raffle.

The idea behind it is that there will be approximately 100 prizes, and 100 raffle tickets drawn. When a ticket is drawn, the winner will have 20 minutes to claim their prize or it is forfeited.

In the Excel spreadsheet, I need to have a row for each prize, along with a countdown timer, and Start, Stop, and Reset buttons. I have gotten the countdown timer and buttons to work for the first row, but how can I repeat this for each additional row, so that I don't have to have 100 copies of the functions that I have written?

Here are my functions:

Please Login or Register  to view this content.

I am also attaching the current xlsm file, in case that helps. Thank you so much!

[abcrobots]

Hi-
I'm wondering if you solved this problem?
As I tested it, the timer counts down fine, but once timed out, faults and won't reset.
Only one timer works as I can see it.

If you solved it, I'd be interested in what you did?

[scottiex]

You are talking to people who haven't posted here for many years, and even if they did resolve the question, it was years ago. This is not how the administrators want this site to work and doesn't help you much.

What you should do is start your own post and upload a file spelling out exactly what you want to do.
Then someone can advise the best way to do it.
you can link to these threads if you think they help to explain what you want.

FWIW your request sounds like it will be pretty straightforward - but create the new thread first.