Multiple Timers, Multiple Events

**singinwes** · 07-30-2020, 02:38 PM

I am well experienced in Excel, but am starting my first real VBA project. I have typically found what I've needed in the past and copied and pasted it, but I know that won't be the case for this project. I have researched event handlers and basic countdown timers, but I haven't figured out how to piece this idea together.

Basically, I need a separate hour long timer in each row that starts when something is entered into that row's column B. With just a basic timer and event handler, I'm able to call a start_timer when something is entered into B:B, but that only works with one row. I have thought of running separate modules per row (start_timerF, start_timerG, etc.) but that would be dozens of modules running and I doubt that's the best way to move forward. I'm not necessarily hoping for a copy paste answer, though that would be incredible. I'm just hoping someone here knows of the right path forward for me to figure this out. I appreciate your time and any help you can provide!

**Greg M** · 07-30-2020, 04:44 PM

Hi there,

Take a look at the attached workbook and see if it gets you moving in the right direction. It uses the following code in the VBA CodeModule for the worksheet:

Please Login or Register  to view this content.

The highlighted values may be altered to suit your requirements, but note that the following line:

Please Login or Register  to view this content.

assumes that the "Start" and "Elapsed" columns are adjacent to each other.

Hope this helps - please let me know how you get on.

Regards,

Greg M

**singinwes** · 08-04-2020, 09:16 AM

This is super helpful and we can make this work swimmingly, thank you! I'm wondering if it's possible to make each line stop when it hits an hour. Everything I have thought of would stop all of them when the first one hits an hour. Any insights into accomplishing this?

**singinwes** · 08-04-2020, 10:40 AM

I changed Const sFORMULATE to "=IF(NOW()-INT(NOW())-RC[-1]<0.04167,NOW()-INT(NOW())-RC[-1],0.04167)" and was able to have each line item stop as an hour. This made our project exactly as we had hoped, thank you for your help!

**Greg M** · 11-29-2020, 08:32 PM

Hi again,

Sorry about the delay in replying - other projects got in the way of the forum!

Many thanks for all of your feedback and also for the recent Reputation increase - much appreciated!

You're welcome - glad I was able to help.

Best regards,

Greg M

Multiple Timers, Multiple Events

LinkBack

Thread Tools

Rate This Thread

Display

Multiple Timers, Multiple Events

Re: Multiple Timers, Multiple Events

Re: Multiple Timers, Multiple Events

Re: Multiple Timers, Multiple Events

Re: Multiple Timers, Multiple Events

Thread Information

Users Browsing this Thread

Similar Threads

Excel VBA - Multiple procedures in 1 sheet to set up multiple timers

multiple timers

Multiple timers

Multiple Countdown timers.

Multiple Timers within EXcel

Setup Multiple Timers

Running multiple timers

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions