How to Create Live Clock
#1 Under a form design view, insert a text box and name it as “TextTime”
You can format it as you want it to be looked like.
#2 On the from property sheet, set Timer Interval to 125 and then select the Event Procedure under the On Timer
#3 Insert the VBA code below under the Form Timer Event Procedure.
Private Sub Form_Timer()
Me.TextTime.Value = format(Time, “HH:mm:ss AM/PM”)
End Sub
#4 Insert Date and Time from the Design menu. Choose a long date format as shown in the picture below then click OK.
#5 Save and view form. The current date and time will display. The second of current time is changing displayed as a live clock. It is one cool feature that makes you form look professional.
