Thanks Tom - I will have a play around with your suggestion and see how far
I get.

"Tom Ogilvy" wrote in message
...
Generally, you insert a userform and put a label on it. Make it as wide
as you need. then you show the form

userform1.show

in the initialize event you could do

Private sub Userform_Initialize()
label1.caption = _
"Copy Information from:- C:\Documents and Settings\abevan\My" & _
"Documents\SM Partition\Drive_H\WIP\WIP - Weekly Checkin\Start"
End sub

back to the message box, you could try:

Sub showmsg()
sStr = "Copy Information from:"
sStr1 = "C:\Documents and Settings\abevan\My" & _
"Documents\SM Partition\Drive_H\WIP\WIP - Weekly Checkin\Start"
MsgBox sStr & vbNewLine & sStr1

End Sub

That might work for you



--
Regards,
Tom Ogilvy

"Andibevan" wrote in
message
...
Tom,

You may well be right - I seem to remember that you can generate a line
of
code to generate a userform - am I correct or imagining things?

Ta

Andy

"Tom Ogilvy" wrote in message
...
I believe it can be resized using the windows API, but code I have
seen
to
customize a message box is voluminous - easier to use a userform I
would
think.

--
Regards,
Tom Ogilvy


"Andibevan" wrote in
message
...
Hi All,

I am trying to display a large amount of information to the user
within
a
message box but can't work out how to specify the width of the box.

As the width of the box is too small, my text word wraps whereas I
want
each
piece of information to be contained on a seperate line.

Is it possible to set the size of a message box or do I need to use
a
useform.

Would really appreciate it if someone could give me a pointer.

Thanks

Andy