Using Windows Usernames

[Ste_Moore01]

Hi,

I'm creating a spreadsheet for quotations to our customers and we need to show who has created the quote in case the customer needs to contact them.

I was wondering, is it possible for Excel to find out the username that Windows is logged in as and autmatically input it into a cell?

 

[Andrew Poulsom]

Try:

Sub Test()
    MsgBox Environ("UserName")
End Sub

 

[Ste_Moore01]

Thanks very much Andrew!