Microsoft KB Archive/63134

{| = Macro to Display Time in Status Bar in Excel =
 * width="100%"|

Last reviewed: November 4, 1994

Article ID: Q63134

SUMMARY
The following Microsoft Excel macro will display the current time in the status bar. The time will be updated every minute. This macro will run every minute until interrupted by pressing the ESC key.

A1: =MESSAGE(TRUE,TEXT(NOW,&quot;h:mm&quot;)) A2: =ON.TIME(NOW+0.00069,&quot;Time.xlm!time&quot;) A3: =RETURN It is assumed that the macro sheet is named &quot;Time.XLM&quot; and that Cell is defined as &quot;time&quot;. The time format &quot;h:mm&quot; can be changed to the desired format.
 * }