Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Get a date to display in date format on a UserForm | Excel Programming | |||
Date on UserForm | Excel Programming | |||
Userform Date | Excel Programming | |||
Date in userform being saved as general not date which affects sor | Excel Programming | |||
Userform to select start date and end date | Excel Programming |