VBA User Information Msgbox

[Pinaceous]

Hello everyone,

I'm using an excel sheet that can be accessed by many users.

When each user opens their excel document, in the top right hand side of the screen appears the user's name.

My question is, could I launch a msgbox popup to include the name of the user who is signed in in a message box popup?

For example, an employee named Bob Parker is signed into their excel document as Parker, Bob.

Could a msgbox would be designed to include the user's name?

For example:

 Msgbox " [Username] Hello!"

would appear

"Bob Parker Hello!"​

when run.

Is this possible?

Please let me know when you get a chance.

Thank you,
pinaceous

 

[Norie]

Try this.

MsgBox Application.UserName & " Hello!"

 

[Pinaceous]

Hi Norie,

The way that the administrator setup the excel, that approach did not work.

The message box pops back authorized user in place of the application.username.

Is there any additional information that I could provide to help you?

Thank you,
pinaceous

 

[Norie]

You could try using Environ("Username") instead.

 

[Pinaceous]

Could you please give me an example in a code?

 

[Norie]

All you need to do is replace Application.UserName.

MsgBox Environ("UserName") & " Hello!"

 

[Pinaceous]

All you need to do is replace Application.UserName.

MsgBox Environ("UserName") & " Hello!"

Okay I see. Thank you for explaining that via code. Let me try it a go. ✌

 

[Pinaceous]

Hi Norie,

It does work but it displays the employees code that is assigned to each individual in using the code from Post#7.

Is there some other code that we can try to isolate the name, which is signed into the excel sheet?

Thank you,
pinaceous