ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to insert os or office user-name in excel? (https://www.excelbanter.com/excel-discussion-misc-queries/175396-how-insert-os-office-user-name-excel.html)

hownw

How to insert os or office user-name in excel?
 
I am creating a form for multiple users, so whenever a user use the form,
there will be a cell reflecting the user name. This is to track who use and
printed the form.

Bob Phillips

How to insert os or office user-name in excel?
 
In VBA

Environ("UserName") gives you the logged on user.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"hownw" wrote in message
...
I am creating a form for multiple users, so whenever a user use the form,
there will be a cell reflecting the user name. This is to track who use
and
printed the form.





All times are GMT +1. The time now is 07:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com