How to get an enter in a msgbox?

MJA · Mar 23rd, 2002, 09:01 AM

Hello,

I want to have the following sentences in a msgbox in exact the same way:

You have made an error!
Plaese erase cell A1
Thank you!

I get the sentences after each other, how do I insert a 'enter'?!?!

Jay Petrulis · Mar 23rd, 2002, 09:09 AM

Hi,

At least three ways. All return the same thing...

MsgBox "You have made an error" & vbCr & "Please erase cell Al" & vbCr & "Thank you"

MsgBox "You have made an error" & Chr(10) & "Please erase cell Al" & Chr(10) & "Thank you"

MsgBox "You have made an error" & Chr(13) & "Please erase cell Al" & Chr(13) & "Thank you"

MJA · Mar 23rd, 2002, 09:13 AM

Quote:

On 2002-03-23 08:09, Jay Petrulis wrote:
Hi,

At least three ways. All return the same thing...

MsgBox "You have made an error" & vbCr & "Please erase cell Al" & vbCr & "Thank you"

MsgBox "You have made an error" & Chr(10) & "Please erase cell Al" & Chr(10) & "Thank you"

MsgBox "You have made an error" & Chr(13) & "Please erase cell Al" & Chr(13) & "Thank you"

Thank U!!!

Mar 23rd, 2002, 09:01 AM	#1
MJA Board Regular Join Date: Feb 2002 Location: Hengelo Posts: 79	Hello, I want to have the following sentences in a msgbox in exact the same way: You have made an error! Plaese erase cell A1 Thank you! I get the sentences after each other, how do I insert a 'enter'?!?! __________________ Best regards, Martin J.A. Maatman Oonk

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 23rd, 2002, 09:09 AM	#2
Jay Petrulis MrExcel MVP Join Date: Mar 2002 Location: Chicago, IL USA Posts: 2,042	Hi, At least three ways. All return the same thing... MsgBox "You have made an error" & vbCr & "Please erase cell Al" & vbCr & "Thank you" MsgBox "You have made an error" & Chr(10) & "Please erase cell Al" & Chr(10) & "Thank you" MsgBox "You have made an error" & Chr(13) & "Please erase cell Al" & Chr(13) & "Thank you"