"Harlan Grove" wrote in message
ups.com...
Gareth Evans wrote...
Is it possible for the Time Function to be live, rather than the time that
the forumla was edited.

It is live to the extent it'll recalculate upon any recalculation in
addition to reentry. If you mean you want a cell to keep ticking away,
showing the current time when there's no user intervention whatsoever,
it can be done, but in spreadsheets IT'S A **VERY** BAD IDEA. Why?
Because it requires running a macro that repeatedly calls itself using
the Application.OnTime method, and that makes not only Excel but the
whole system SLOW.

Since users can choose to display a clock in their task bar, why do you
believe you need to provide a redundant clock in your workbook?

I wanted to create a program that showed the minutes and seconds left to a
deadline. Though for this job it would probably be better to create a small
program, rather than use a spreadsheet.

It was out of curiousity really.

Thanks for your reply.

Gareth