MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Insert user name in cell

  Asked By: Ludwig    Date: Jan 21    Category: MS Office    Views: 5357

I have almost finished my project on creating a quotation sheet, I am
stuck on one item. I would like to add the computer user's name in a
cell (C9)

Many thanks for your help in the past, and look forward to your help



3 Answers Found

Answer #1    Answered By: Monique Perry     Answered On: Jan 21

Away from the office.....
I believe it goes something like:

TempVariable = environ ("ComputerName")
TempVariable = environ ("Computer")

Answer #2    Answered By: Roosevelt Jenkins     Answered On: Jan 21

In VBA I think you'd use something like...

Cells(x, y) = Application.UserName

Answer #3    Answered By: Rosie Hughes     Answered On: Jan 21

msgbox environ("Username")

gets you the logged in name.

Didn't find what you were looking for? Find more on Insert user name in cell Or get search suggestion and latest updates.