Using a macro, how do I pull in the user's name, specifically, the last
character in the name?

Thanks.

Dim myName as string
myname = application.username 'from the Tools|Options|General tab
msgbox right(myname,1)


WLMPilot wrote:

Using a macro, how do I pull in the user's name, specifically, the last
character in the name?

Thanks.

--

Dave Peterson

Right(Environ("UserName"),1)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"WLMPilot" wrote in message
...
Using a macro, how do I pull in the user's name, specifically, the last
character in the name?

Thanks.