Help with InputBox and MsgBox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want an InputBox and MsgBox to display several lines on text and want to be
able to hit carriage-return so that the text reads like a paragraph.

I have the following :-

Title = "Please Enter Password to LOCK ALL the sheets"
MSG1 = ("Enter Password and Select OK")
resp1 = InputBox(MSG1, Title)

How could I format the above to say have a carriage return after "Enter
Password"?
 
MSG1 = "Enter Password" & vbCr & "and Select OK"

vbCr is a "constant" and is the same as Chr(13) which is the carriage return character.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Ann" <[email protected]>
wrote in message
I want an InputBox and MsgBox to display several lines on text and want to be
able to hit carriage-return so that the text reads like a paragraph.
I have the following :-

Title = "Please Enter Password to LOCK ALL the sheets"
MSG1 = ("Enter Password and Select OK")
resp1 = InputBox(MSG1, Title)

How could I format the above to say have a carriage return after "Enter
Password"?
 
Back
Top