View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Coder1215 Coder1215 is offline
external usenet poster
 
Posts: 12
Default 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