Thread: Message Box
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alan Alan is offline
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.