View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default To display message in 2 different lines

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

--
Regards
Frank Kabel
Frankfurt, Germany


Hari wrote:
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