Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike
 
Posts: n/a
Default Entering NT User name in Cell

Hi all,

I'm trying to write a macro that will allow the user to click a button in a
workbook, which in turn will poulate the cell with they're NT User name.

Mike
  #2   Report Post  
Posted to microsoft.public.excel.misc
Norman Jones
 
Posts: n/a
Default Entering NT User name in Cell

Hi Mike.

Try:

Range("A1").Value = Environ("Username")



---
Regards,
Norman


"Mike" wrote in message
...
Hi all,

I'm trying to write a macro that will allow the user to click a button in
a
workbook, which in turn will poulate the cell with they're NT User name.

Mike



  #3   Report Post  
Posted to microsoft.public.excel.misc
cdb
 
Posts: n/a
Default Entering NT User name in Cell

Is there anyway of doing this in a workbook without a macro?

cdb

"Norman Jones" wrote:

Hi Mike.

Try:

Range("A1").Value = Environ("Username")



---
Regards,
Norman


"Mike" wrote in message
...
Hi all,

I'm trying to write a macro that will allow the user to click a button in
a
workbook, which in turn will poulate the cell with they're NT User name.

Mike




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
Dates of a Day for a month & year cell formulas mikeburg Excel Discussion (Misc queries) 2 December 29th 05 10:14 PM
Instead of a negative number, I'd like to show zero... Dr. Darrell Excel Worksheet Functions 6 December 7th 05 08:21 PM
Can a macro be made to run on entering or leaving a cell? Dave Lister Excel Discussion (Misc queries) 1 December 3rd 05 07:11 PM
Preventing user entering duplicate values in a cell range Thomas Peters Excel Worksheet Functions 1 November 30th 05 08:00 PM
cell color index comparison MINAL ZUNKE New Users to Excel 1 June 30th 05 07:11 AM


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

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"