Countdown Timer

**colt seavers** · 01-11-2010, 09:30 AM

Got a formula to create a countdown - hours, mins, secs that kind of thing.

Can press and hold F9 to show it moving.

What sort of macro do I need to have it continually counting down?

Thanks

**Palmetto** · 01-11-2010, 10:33 AM

What sort of macro do I need to have it continually counting down?

A simple Forum or Google search on the terms . . Countdown Timer .. would yield many relevant results.

Here is a start: VBA Count Down Timer

Cell Countdown Timer

**colt seavers** · 01-12-2010, 11:06 AM

Got a macro which I've recorded to F9

Sub UPDATE()
'
' UPDATE Macro
' Macro recorded 08/01/2010 by u22130
'

'
Calculate

End Sub

Just want this to repeat or loop to show the seconds moving?

Any ideas?

**Palmetto** · 01-12-2010, 12:23 PM

First, your last post does not comply with the Forum Rules regarding use of code tags for VBA code.

Please amend your thread to apply code tags per rule #3.

Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # button at the top of the post window. If you are editing an existing post, press Go Advanced to see the # button. For more information about these and other tags

Why don't you use one of the code samples provided? It's what you asked for.