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
|