Format of a msgbox
 

Hi everyone,

I have a number of msgboxes throughout my spreadsheet.
My problem is this: several of the msgboxes contain long lists o
names, which currently rap across lines and although separated b
commas they are very unreadible.

Is there a method to format the msgbox so that certain names can b
shown below each other to make it easier to read.

Thank you in advance.
Scott

--
scottwilson
-----------------------------------------------------------------------
scottwilsonx's Profile: http://www.excelforum.com/member.php...fo&userid=1112
View this thread: http://www.excelforum.com/showthread.php?threadid=27835

Format of a msgbox
 

scottwilsonx,

This may not be what you want but it does what I want.




MsgBox "Phone Nr.For Sto " & vbCrLf & .ListBox2.Text _
& vbCrLf & "Address: " & ActiveCell.Offset(0, 2).Tex
_
& vbCrLf & "City : " & ActiveCell.Offset(0, 3).Text _
& ", " & ActiveCell.Offset(0, 4).Text _
& vbCrLf & "Is: " & ActiveCell.Offset(0, 5).Text _
& vbCrLf & "Hours : " & " " & ActiveCell.Offset(0
7).Text _
& " " & ActiveCell.Offset(0, 8).Text & vbCrLf & _
"Sat Hours : " & ActiveCell.Offset(0, 9).Text & " " _
& ActiveCell.Offset(0, 10).Text & vbCrLf _
& "Sun Hours : " & ActiveCell.Offset(0, 11).Text _
& " " & ActiveCell.Offset(0, 12).Text & vbCrLf _
& "DSM : " & ActiveCell.Offset(0, 13).Text
vbCrLf _
& "RSM : " & ActiveCell.Offset(0, 14).Text

Charle

--
Charle
-----------------------------------------------------------------------
Charles's Profile: http://www.excelforum.com/member.php...nfo&userid=601
View this thread: http://www.excelforum.com/showthread.php?threadid=27835