LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 683
Default Changing Meassage Box Title

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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Simple meassage box Les Excel Programming 2 March 30th 07 12:02 PM
Changing title from default toocold Excel Programming 8 February 16th 06 01:18 AM
Can I add a Warning Meassage to a Macros Designed to Delete a Row C Bonovich Excel Worksheet Functions 1 June 2nd 05 07:32 AM
changing the application name in the title bar Paul James[_3_] Excel Programming 11 December 23rd 03 12:31 AM
changing chart title via vba? basis[_2_] Excel Programming 0 October 20th 03 05:47 PM


All times are GMT +1. The time now is 12:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"