Inserting User Name into a cell

T

Trish

I am setting up a tracking form, which will be accessed by
all staff members. If possible I would like the next cell
(log number) to recognise the computer user name. Can
anyone help please :)
 
B

Bob Phillips

You need VBA. Create a sub with this code

Sub UserName()
ACtivecell.Offset(0,1).Value = Environ("username")
End Sub

and run it from the original cell.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top