User I.D.

Posted by robert yerby on December 05, 2001 9:20 AM

Is there any code for capturing the user name (as stored in Tools, Options, General, User name)
and placing it in a cell (say to the left) of data
they are inputting

regards
Robert

Posted by giacomo on December 05, 2001 9:31 AM

Sub userName()
ActiveCell.Value = Application.userName
End Sub