Inserting User Name into a cell
 

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 :-)

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)


"Trish" wrote in message
...
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 :-)