Countdown Timer for Excel

Completed Posted 7 years ago Paid on delivery
Completed Paid on delivery

Hi,

I have a spreadsheet (attached) that populates data 5 times per second from an external source using COM.

Data is populated in various places but the relevant part is range O5-O45 on sheet W1. I want a timer to start automatically at 3 seconds and run down each time two or more values in that range are equal to or less than 2, ignoring blank cells.

Some more details:

1. if on a subsequent refresh of the data two or more values are again equal to or less than 2 the countdown should restart at 3, even if the previous countdown has not reached 0;

2. on reaching 0 the cell should return to empty;

3. the timer should appear in cell AF5 of sheet W1;

4. there is other code in the spreadsheet and it will need to run alongside that without conflict. It will also need to run alongside other spreadsheets containing VBA without conflict;

Thanks

Visual Basic for Apps

Project ID: #10900362

About the project

7 proposals Remote project Active 7 years ago

Awarded to:

diorisaguilar

Hi, I am a software developer and I just downloaded the attached spreadsheet. I added the counter checking changes in the mentioned cell range. This counter will start when it detects a change and there are 2 or more c More

$20 USD in 0 days
(2 Reviews)
1.0

7 freelancers are bidding on average $37 for this job

surekash7096

I have the expertise in Excel and scripting in VBA to do the task of creating the Countdown Timer. Ready to start work immediately.

$35 USD in 1 day
(1 Review)
2.8
slenders13

Dear client, I have a lot of experience with VBA and Excel. Send me a message for more information. Looking forward to work with u. Kind regards, SlenDATA

$30 USD in 2 days
(2 Reviews)
2.6
psprongs

Hi, I jave over 3 years in developing functions/macros and add-ins for excel. I can create a timer that starts eveytime cells O5-O45 is updated and there are 2 or more values less than or equal to 2 and when timer expi More

$25 USD in 1 day
(1 Review)
2.5
furqanshakoor

Hi Please have a look at my profile, I am expert in macros and timers. Done a similar project with excel timer and with the windows scheduler also. I am rated 5 out of 5 for my project done here. Can start immedi More

$25 USD in 1 day
(0 Reviews)
0.0