Log User Name and Date when userform was run/modified
 

Is there a code that will log when and who last opened and used a userform?

Corey....

Log User Name and Date when userform was run/modified
 

Corey,
Environ("UserName")
Now()

Although some prefer the API route:
Declare Function GetUserName Lib "advapi32.dll" Alias "GetUserNameA" (ByVal
lpBuffer As String, nSize As Long) As Long

As for the logging, depends where you want the info to go, but I imagine
triggered by the userform Initialize or Terminate events.

NickHK

"Corey" wrote in message
...
Is there a code that will log when and who last opened and used a
userform?

Corey....