View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Julian Julian is offline
external usenet poster
 
Posts: 13
Default Display date and time

Hi JLGWhiz,

Thanks for the info,
I'm creating a userform which i want to display the date and time in the
corner.
The problem i'm facing now is that the date and time refreshes whenever i
click it.
I want it to function like a digital clock. I hope you get my idea.

Please advice

"JLGWhiz" wrote:

There is also a keyboard shortcut for calling date and time:

Ctrl + ; for date and Ctrl + Shift + ; for time.

They did away with the clock feature in the Windows package. I used to have
it displayed in digital format in a corner of my screen. The 2003 version
has it on the status bar at the bottom now. You should be able to use one of
those that I have suggested.

"Julian" wrote:

How can i display the date and time at real-time?Below is the script. Please
advice..

Private Sub txtTimeDAte_Change()

Dim MyDate

MyDate = Now ' MyDate contains the current system date.

txtTimeDAte.Text = Format(MyDate, "dd,mmm yy hh:mm:ss AMPM ")

End Sub


Julian