Wrapping Sentences In VBA Code
Posted by Jerry on March 03, 2001 2:08 PM
Excel 97...
Does anyone know the syntax to wrap the sentence following the words Response =
Sub InputBox_Function()
Response = InputBox("Enter The Week Ending Date (Saturday) For The New Report Example 3/10/01", "WEEK ENDING")
Posted by Roger Redhat on March 04, 2001 11:37 AM
If you use this code:-
YourText="Response = " & vbCrLf & Response
The vbCrLf is a VB constant that will add a carriage return and line feed to a string wherever it's added.
