How to put a 'return' in Msgbox?

H

HausMaus

Hi

I would like to know if it's possible to make a message(-box)
consist of 2 lines with the help of some sort of a 'return-function'?
How do I do this? (What's the command?)

I've tried several things but notihng seems to work...

(thanks!)

Pau
 
C

Chip Pearson

Paul,

Try something like the following:

MsgBox "Line one" & vbNewLine & "Line two"



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
F

Frank Stone

I'm not exactly sure what you mean by 2 lines
here is a msgbox i use to create 3 lines.
MsgBox ("Macro Complete." & Chr(13) & "Items in blue may
need ordering." & Chr(13) & "Items in Yellow are
discontinued items.")
 
G

Gord Dibben

Paul

msgbox "This is line one" & vbLf _
& "This is line two" & vbLf _
& "This is line three"

Gord Dibben Excel MVP
 
Top