Down-counter

[bjoern]

Hi all.

I need a timer of sorts that counts backwards and when it hits '0' it stops and emits a beep or plays a wav file. Simply put: I enter, say 1000 seconds in one cell, hit a button and the countdown starts, displaying the time left in another cell.

Any help or ideas appreciated,
Bjoern

[Colin Legg]

Hi,

Do you want the timer to continue counting down even if Excel is in edit mode?

[fomoz]

Please Login or Register  to view this content.

[e4excel]

Bjoern,

I had asked a similar query a few months back and I had found something in GOOGLE which yu might find useful so adding it, though I had not received a solution on the forum for this query the attachemnt may be helpful incase you are good in VBA

http://www.excelforum.com/excel-work...-in-excel.html

Regards
e4excel

[Colin Legg]

I've posted some code which will do this and will continue to run even if Excel is in edit mode. It was adapted from a post by Jaafar Tribak as mentioned in the code comments.

Standard code module

Please Login or Register  to view this content.

Sheet1 Class Module

Please Login or Register  to view this content.

I have attached an example. Simply open the workbook and click the 'Start Timer' button.
The worksheet_calculate event handler will not run while Excel is in Edit mode and I make no guarantees about the stability of the application!

[bjoern]

Thanks fomoz, however, it fails to compile because 'PlayWav' is not deifned as a sub or function.

Bjoern