PDA

View Full Version : [SOLVED] Multi line MsgBox



austenr
08-16-2005, 01:19 PM
I know I have found this somewhere but I for got where. How can you make a Msgbox more than one line?

MWE
08-16-2005, 01:23 PM
I know I have found this somewhere but I for got where. How can you make a Msgbox more than one line?
if I understand your question correctly, simply insert a "line feed" into the Prompt string each time you want to go to the next line. For example:


Msgbox "this is the first line" & vbcrlf & "and this is the second"

austenr
08-16-2005, 01:29 PM
Thanks. Was missing an & sign. Solved.

royUK
08-17-2005, 01:40 AM
Possibly easier to remember is vbNewLine. It does exactly the same thing.

Bob Phillips
08-17-2005, 02:36 AM
Possibly easier to remember is vbNewLine. It does exactly the same thing.

More importantly, it also works on the Mac.