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
|