How to go to make a MsgBox message go to the next line if it....

[PorscheGT2]

.. doesnt fit the screen.

I know you use the underscore symbol to do that, but how? TIA!

 

[Sean7174]

Not sure what you are asking. To make a multi line msgbox use vbCrLf (see also vbCr and vbLf) To split a line of code on two lines, end the first line with a space and then a under score " _"


Sub example()
MsgBox "This is line 1" & vbCrLf & "This is line 2"
MsgBox "This is a very long..." _
& "line" 'second line of code
End Sub

 

[Chattin]

Check out the VBE help on 'Miscellaneous Constants' for more info on vbCrLf, vbCr etc

Chris ;-)

Visit

http://www.mrexcel.com/board/index.php

for great xl and xl/VBA help