software

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

Hi Mike.

Try:

Range(quot;A1quot;).Value = Environ(quot;Usernamequot;)
---
Regards,
Normanquot;Mikequot; gt; wrote in message
...
gt; Hi all,
gt;
gt; I'm trying to write a macro that will allow the user to click a button in
gt; a
gt; workbook, which in turn will poulate the cell with they're NT User name.
gt;
gt; Mike
Is there anyway of doing this in a workbook without a macro?

cdb

quot;Norman Jonesquot; wrote:

gt; Hi Mike.
gt;
gt; Try:
gt;
gt; Range(quot;A1quot;).Value = Environ(quot;Usernamequot;)
gt;
gt;
gt;
gt; ---
gt; Regards,
gt; Norman
gt;
gt;
gt; quot;Mikequot; gt; wrote in message
gt; ...
gt; gt; Hi all,
gt; gt;
gt; gt; I'm trying to write a macro that will allow the user to click a button in
gt; gt; a
gt; gt; workbook, which in turn will poulate the cell with they're NT User name.
gt; gt;
gt; gt; Mike
gt;
gt;
gt;