MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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