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

--
Message posted from http://www.ExcelForum.com

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



"HausMaus " wrote in
message ...
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!)

Paul


---
Message posted from http://www.ExcelForum.com/

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.")
-----Original Message-----
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!)

Paul


---
Message posted from http://www.ExcelForum.com/

.

Paul

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

Gord Dibben Excel MVP

On Tue, 10 Aug 2004 13:32:08 -0500, HausMaus
wrote:

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!)

Paul


---
Message posted from http://www.ExcelForum.com/