98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel learn london - MsgBox
excel learn london - MsgBox
Resolved · Low Priority · Version Standard
Neil has attended:
Excel VBA Intro Intermediate course
MsgBox
What code do I use to get the message across more than one line in the box?
RE: MsgBox
Hi Neil,
To extend the message within a msgbox, you add the following VBconstants in between the text message:
vbCrLf [to insert Carriage Return + Linefeed]
vbLf [to insert Soft Carriage Return + Linefeed]
vbCr [to set a new line]
vbTab [to insert a tab]
vbBack [to Backspace]
Hope this helps.
Regards,
Katie
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Brighten up your Excel 2010 Spreadsheet by changing the colours of the gridlinesExcel 2010 allows you to change the colour of grid lines instead of keeping them in boring black. |