Mon 21 Jan 2008, 16:43Delegate Neil said...
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?
Mon 21 Jan 2008, 17:21Trainer Katie said...
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
