View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz[_2_] JLGWhiz[_2_] is offline
external usenet poster
 
Posts: 1,565
Default Changing Meassage Box Title

This line:

MsgBox Msg


To:

MsgBox Msg, , "Title"

Substituye your title for the word "Title". Note the commas.




"Brian" wrote in message
...
I have a message box that I would like to change the title of. Right now it
say's Microsoft Excel

Here is the code I have, but I am missing something. According to the book
I
have this should work.

'Greeting Message Bob
Dim Title As String

If Me.Engineer_2.Value = "Bozeman" Then
If Time < 0.5 Then
Msg = "Morning "
ElseIf Time < 0.75 Then
Msg = "Afternoon "
Else
Msg = "Evening "
End If

Msg = "Good " & Msg & "Mr. Bozeman"
Msg = Msg & vbNewLine & vbNewLine
Msg = Msg & "Welcome to the C.E.S."
MsgBox Msg

Title = "C.E.S."

End If

Any ideas?