Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pbs pbs is offline
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,058
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Force user to enter data in cell before moving to next cell Fusionmags New Users to Excel 3 November 19th 06 11:49 PM
User must enter something in a range of cells Jugglertwo Excel Discussion (Misc queries) 4 July 27th 06 05:36 AM
How do I input a warning message to remind the user to enter into. sugarbrit17 Excel Discussion (Misc queries) 3 January 25th 05 08:31 PM
Avoid user having to enter hours when using [mm]:ss format Lady_luck Excel Discussion (Misc queries) 3 January 4th 05 10:50 AM
Avoid user having to enter 00 hours when using [mm]:ss format Lady Luck Excel Discussion (Misc queries) 4 January 2nd 05 06:56 PM


All times are GMT +1. The time now is 08:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"