Update time for the userform.caption

[DragonBall_6]

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]

Userforms don't display time unless you refresh the .Caption at intervals.

OnTime would be what I looked at.