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