Countdown Timer for Excel


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;


Habilidades: Visual Basic para Apps

Veja mais: visual basic for applications, daily log count excel, count excel data, automatic letter count excel, vbscript count excel files folder recursive, cash count excel sheet, count excel words special characters, letter count excel, finding count excel, word count excel different word, word count excel, lost timer countdown software, excel spreadsheet stock details, excel 2007 lock cell data refresh, great plains cycle count excel, flash cs4 digital timer countdown, excel world contact details, as3 animated timer countdown, count excel, script count excel files folder

Acerca do Empregador:
( 6 comentários ) United Kingdom

ID do Projeto: #10900362

Concedido a:


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 Mais

$20 USD em 0 dias
(2 Comentários)

7 freelancers estão ofertando em média $37 para esse trabalho

$100 USD em 1 dia
(12 Comentários)

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 em 1 dia
(1 Comentário)

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 dias
(2 Comentários)

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 Mais

$25 USD em 1 dia
(1 Comentário)
$25 USD em 1 dia
(1 Comentário)

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 Mais

$25 USD em 1 dia
(0 Comentários)