How do I get a msgbox to have to text stacked instead of in a line?
for example have

'costid = ""
linkno = ""

in the msgbox instead of

cost id = "" linkno = ""

Thanks

try:

Dim msg as string

msg = "costid = " & vbCrLf
msg = msg & "linkno = "
msgbox msg
--

Karen53


"ranswert" wrote:

How do I get a msgbox to have to text stacked instead of in a line?
for example have

'costid = ""
linkno = ""

in the msgbox instead of

cost id = "" linkno = ""

Thanks

msgbox "Costid = " & somevariable & vblf & "LinkNo = " & someothervariable

If you're using a Mac, change that vblf to vbNewLine.
(actually vbNewLine will work on either wintel or macs.)


ranswert wrote:

How do I get a msgbox to have to text stacked instead of in a line?
for example have

'costid = ""
linkno = ""

in the msgbox instead of

cost id = "" linkno = ""

Thanks

--

Dave Peterson

hi
msgbox (" item1" & vbnewline & "item1")

you can also use vblf o

regards
FSt1

"ranswert" wrote:

How do I get a msgbox to have to text stacked instead of in a line?
for example have

'costid = ""
linkno = ""

in the msgbox instead of

cost id = "" linkno = ""

Thanks

thanks I'll give those a try

"ranswert" wrote:

How do I get a msgbox to have to text stacked instead of in a line?
for example have

'costid = ""
linkno = ""

in the msgbox instead of

cost id = "" linkno = ""

Thanks

MsgBox "cost id = """"" & vbLf & "linkno = """""


Gord Dibben MS Excel MVP

On Fri, 15 Feb 2008 13:14:00 -0800, ranswert
wrote:

How do I get a msgbox to have to text stacked instead of in a line?
for example have

'costid = ""
linkno = ""

in the msgbox instead of

cost id = "" linkno = ""

Thanks