Hi All,

       I need the VBA code to display the time in Excel.I used the "Time" function but it is not showing the running time.It is showing the fixed time i.e., The Time when we compiled the code but i want the dynamic time i.e., The Time must be updating for every second (Running or Dynamic Time).
               Plz anybody help me in this regard.
                                                   Thank you:)

Add a Timer Control to your form and set the timer interval.

In the Timer event for that timer set (refresh) the time

Private Sub Timer1_Timer()

    Label1.Caption = Date & " " & Time

End Sub


Private Sub UserForm_Initialize()
 Timer1.Interval = 1000
End Sub

Cheers
Shasur

http://www.vbadud.blogspot.com