Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help with InputBox and MsgBox
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"? -- Thank U and Regards Ann |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help with InputBox and MsgBox
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" 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"? -- Thank U and Regards Ann |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help with InputBox and MsgBox
Jim,
Thank you for youkind help. -- Thank U and Regards Ann "Jim Cone" wrote: 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" 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"? -- Thank U and Regards Ann |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inputBox calculations and msgbox or "outputBox" | Excel Worksheet Functions | |||
msgbox / inputbox etc | Excel Discussion (Misc queries) | |||
msgbox / inputbox etc | Excel Worksheet Functions | |||
msgbox / inputbox etc | Setting up and Configuration of Excel | |||
Inputbox with VBA | Excel Discussion (Misc queries) |