View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default 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....