Date on UserForm?
Hi,
I don't know if this answers your question exactly, but there is an
interesting way to put such information on the form. First you must
put an empty label on the form (with caption set to empty) and put the
following code in the Form initialization event:
Private Sub UserForm_Initialize()
Me.lblFormOpenDateTime.Caption = "This form was opened exactly at
" & vbCrLf _
& Date & " " & Time & " " & "by user " & Application.UserName
End Sub
Each time the form will be initialized (loaded to memory) you will see
the date/time/user combination in the label. For the change event you
could use timestamp which is also interesting information for the
user.
regards
|