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....
|