msgbox

[ranswert]

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

 

[Karen53]

try:

Dim msg as string

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

 

[Dave Peterson]

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

 

[FSt1]

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

you can also use vblf o

regards
FSt1

 

[ranswert]

thanks I'll give those a try

 

[Gord Dibben]

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


Gord Dibben MS Excel MVP