PDA

View Full Version : Solved: MsgBox



chem101
11-09-2010, 12:14 PM
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:


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!"

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
11-09-2010, 12:48 PM
like thisMsgBox "Good Morning!",vbokonly,"This is the morning title"

chem101
11-09-2010, 12:51 PM
That works great!

Thank you very much!!