excel noob, inputting my user name into a cell

[/\ndy]

Am looking to have a command button on my spreadsheet that inputs my windows logon/outlook name into a specfied cell, does anyone know how I would go about this?

Thanks

 

[A[L]C]

http://blogs.officezealot.com/charles/archive/2004/12/10/3574.aspx

Try that

 

[/\ndy]

Thanks for reply, I've tried that and similar methods, but whenever I try to declare the function in a cell I.e =username() the cell juts shows #NAME?

Any idea what might be causing this?

 

[monkehhh]

Go to your spreadsheet's code, insert a new module (don't add to the sheets or ThisWorkbook) via the menu, paste the function in the new module's "(General)" section -

Function UserNameWindows() As String
    UserNameWindows = Environ("USERNAME")
End Function

.. then use "=UserNameWindows()" in a cell.

 

[dim_pwn]

Above works great.

 

[/\ndy]

Thanks for all the input,managed to get this working. Another issue I've got, does anyone know how I would pull the header information from a web page to a specific cell in excel?