Displaying message box based on user input.

I currently have a macro that asks a user to enter their initials before it runs as it logs who is using the macro.

Please Login or Register  to view this content.

At the end of the macro I have a msgbox that displays a thank you message.

Please Login or Register  to view this content.

Example: If I enter CJH as my initials the Msgbox says...
Thank you cjh. Enjoy your day.

I would like it to look through an array and substitue the name. So If I enter CJH it will say.....
Thank you Chad. enjoy your day.

I'd tend to do this by storing the initial and user name on a hidden sheet within the workbook with one column for user initials and one column for their name.

That way you could match the initials using a .find (which wouldn't be case sensitive) and it would save you having to define the list of users programmatically.

i.e.

Please Login or Register  to view this content.