Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 276
Default 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....


  #2   Report Post  
Posted to microsoft.public.excel.programming
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....




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to change tooltips for user-modified colors? Andy Smith[_2_] Excel Discussion (Misc queries) 1 September 15th 09 12:30 AM
Alert user that row has been modified by changing row color jubu Excel Worksheet Functions 2 June 30th 07 12:46 AM
Last Modified Date help... vmadan16 Excel Programming 0 June 22nd 06 12:40 PM
Conditional Format? - color if cell is modified by user jhs626 Excel Programming 2 August 5th 05 03:03 PM
Finding name of last user who modified Excel Spreadsheet ibeetb Excel Programming 2 July 29th 04 04:02 PM


All times are GMT +1. The time now is 09:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"