PDA

View Full Version : Update time for the userform.caption



DragonBall_6
12-22-2007, 09:24 AM
Dear Expert

May I know how can I update my userform.caption time?
The code below is the time I open the userform and the time is not updated (maintain and stay).

code:
--------
Private Sub UserForm_Activate()
frmTable.Caption = "East Coast Seafood " & Now()
End Sub

May I know how can I update the time?

Thanks

Peter

mikerickson
12-22-2007, 09:34 AM
Userforms don't display time unless you refresh the .Caption at intervals.

OnTime would be what I looked at.