ExcelBanter - enter user in cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - enter user in cell (https://www.excelbanter.com/excel-worksheet-functions/152313-enter-user-cell.html)

pbs

enter user in cell

I wish to enter the logged on user to cell C11.

I ahve done this before, but my mind has gone blank, can anyone help.

Many Thanks

Peter

Gary''s Student

enter user in cell

Try this one line UDF:

Public Function user() As String
user = Environ("username")
End Function

--
Gary''s Student - gsnu200735

"pbs" wrote:

I wish to enter the logged on user to cell C11.

I ahve done this before, but my mind has gone blank, can anyone help.

Many Thanks

Peter

All times are GMT +1. The time now is 04:22 AM.