To display message in 2 different lines

H

Hari

Hi,

In the code if I write
Msgbox "Please enter only yes or no in Column N." _
& " Data cannot be pasted/accepted if anything else is entered."

Then it displays it as

Please enter only yes or no in Column N. Data cannot be pasted/accepted if
anything else is entered."


I want to display the above a message in 2 different lines, like

Please enter only yes or no in Column N.
Data cannot be pasted/accepted if anything else is entered.

I dont want these 2 messages to be displayed in 2 different Msgboxes

Also I want to know whether it is possible to CENTRE the above 2 message in
the msgbox.

Regards,
Hari
India
 
F

Frank Kabel

Hi
Msgbox "Please enter only yes or no in Column N." _
& vblf & "Data cannot be pasted/accepted if anything else is entered."
 
H

Hari

Hi Frank,

Thnx a lot . It worked like a charm.

Just want to know whether it would be possible to Justify/Centre the both
the upper and bottom line.

Regards,
Hari
India
 
D

David

Try This

Msgbox "Please enter only yes or no in Column N." _
& Chr(13) & " Data cannot be pasted/accepted if anything else is entered."

Dave
 
H

Hari

Hi Frank,

Thanx a lot for your reply.

Thanx also to David and urself for teaching me about Char13 and VgLf

Regards,
Hari
India
 
Top