Auto-refresh at regular intervals (Help/guidance required)

[MI man]

Hi,

I have written a one liner VBA code to display the date, time and weekday name on the status bar of Excel (Version used is Excel 2003).

Application.statusbar= date & " " & time & " " & weekdayname(date, vbsunday)

Something of this kind written in Worksheet activate event. (this line may contain errors though, coz I dont have the application in this system that am typing this message, to write the syntax correctly)

It's working, but I want to refresh the time automatically for every second (atleast every 30 secs, or 60 secs) in the background while causing no disturbance to the application while working, something like the Date & time feature that every windows system has on the extreme right bottom of the computer.

Is there a possible way to do this..??

 

[Mr. B]

Here is a link that might get you going:
http://www.exceltip.com/st/Execute_Command/Sub-Procedure_Using_Timer_in_VBA/763.html

and here is another one:
http://social.msdn.microsoft.com/Forums/en/isvvba/thread/35f0de37-2f61-42d9-aa80-2d12a6686f20