Hello All, I am trying to get a splash screen to Say Hello and the
persons name registered to that computer. I have the code to retrieve
the username. The problem is that i have to pieces to a puzzle the
actual splash screen is composed of a userform that I cannot find a way
to enter the MsgBox "Hello " & Application.UserName & ", command this
will give you Hello Person Name, but with a built in msgbox. I cannot
get the msgbox to close automatically after 5 seconds but I can close
the userform after 5 seconds so I have two pieces that I can not find a
way to fit together.
example useform:
Private Sub UserForm_Activate()
Application.OnTime Now + TimeValue("00:00:05"), "KillTheForm"
End Sub

example MsgBox:

MsgBox "Hello " & Application.UserName & ", ?

How can I intergrade these two? I am out of ideas is there anyone that
knows how?