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: 492
Default Message Box

Hi to All,

I want to display the text in a message box on two lines, eg

msgbox "The date you have entered is not valid, Please Re-Enter the date",
vbcritical, "Input Error"

This displays as

The date you have entered is not valid, Please Re-Enter the date

I want it to display as

The date you have entered is not valid,
Please Re-Enter the date

Help says to use line feed characters or carriage return characters, CHR(10)
or CHR(13) or a combination of the two to achieve this, but I cant seem to
get them to work. Can anyone please advise me,

Any help much appreciated,

Regards,

Alan.


 
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
Pop up message box? Graciegirl Excel Worksheet Functions 2 September 23rd 08 11:17 PM
Message Box - more help please !! Anthony Excel Worksheet Functions 4 February 25th 05 03:19 PM
Add a Message Box Anthony Excel Worksheet Functions 2 February 25th 05 03:29 AM
changing the message in an error message The Villages DA Excel Worksheet Functions 2 February 18th 05 05:30 PM
message box swec74 Excel Worksheet Functions 5 January 8th 05 08:55 PM


All times are GMT +1. The time now is 04:52 AM.

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"