Hello again Grammarjunkie,
Code:
MsgBox "Welcome " & Application.Username & "!"
On my PC the above code would display a message box like this:
Application.Username displays the user name of the currently logged user. Feel free to take that bit out if you prefer.
& "!" is just adding the exclamation point on the end. If you would prefer just the word "
Welcome!" the line of code would just read:
With regards to changing fonts, a standard message box is not capable of having the font changed (size, style, colour etc). If you were looking for more customization options then you would need to create and design custom userforms in the VBA Developer window and call those instead of a message box. It isn't
too complicated to do, but is definitely more work than a standard message box.
You can find out more about custom forms as message boxes
HERE (amongst a number of other places no doubt).