Signature Macro

[Keven Hoopiiaina]

I am looking for a macro that I can attach to a button in
an Excel form that will pull either the registry name or
the user name into a field in the form. This would be
similar to a signature macro that is used in Outlook. We
need this for a manager's authorization on a form. Any
help from experts out there would be greatly appreciated!

 

[steve]

Keven,

No expert me, but

Range("A1") = Application.UserName

 

[Peter Atherton]

Keven

Range("A1").Value = Application.UserName

places the user name in A1 of the active sheet. I suppose
you can use something like TextBox1 = Application.userName

Regards
Peter