user name

Posted by Sean on March 14, 2001 9:02 AM

I am creating a template and do not know Visual Basic. How do I get the User Name value from the general options tab into a cell?

Posted by Dave Hawley on March 14, 2001 9:08 AM

Hi Sean

This will do it

Sub TryThis()
Sheets("Sheet1").Range("A1") = Application.UserName
End Sub

OzGrid Business Applications