Signature Macro
 

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!

Signature Macro
 

Keven,

No expert me, but

Range("A1") = Application.UserName

--
sb
"Keven Hoopiiaina" wrote in message
...
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!

Signature Macro
 

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
-----Original Message-----
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!
.