MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.