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

"Hari" wrote in message
...
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