Andy

I'm not sure if you can autosize a messagebox but you could try something
like:

Range("A1").Comment.Shape.Width = 150

Regards
Rowan

"Andibevan" wrote:

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