Solved: MsgBox

[chem101]

Hello Everyone,

I need your help. I'm trying to display a greeting when a user opens a spreadsheet. The greeting changes depending on the time of day. I want to change the title of the message box. I'm not having any luck. Here's what I have so far:

[VBA]
Public Sub Auto_Open()
If Time < 0.5 Then MsgBox "Good Morning!"
If Time >= 0.5 And Time < 0.75 Then MsgBox "Good Afternoon!"
If Time >= 0.75 Then MsgBox "Good Evening!"
[/VBA]
I know the syntax is MsgBox(prompt,[buttons],[title],[helpfile, context]) but I can't seem to enter a title.

Thank you for any assistance you can provide!!

[Simon Lloyd]

like this[VBA]MsgBox "Good Morning!",vbokonly,"This is the morning title"[/VBA]

[chem101]

That works great!

Thank you very much!!