View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Andibevan[_2_] Andibevan[_2_] is offline
external usenet poster
 
Posts: 128
Default Resize Message Box

Sorry Bob,

I think it would be clearer if I gave you the code:-

MsgBox "Copy Information from:- C:\Documents and Settings\abevan\My
Documents\SM Partition\Drive_H\WIP\WIP - Weekly Checkin\Start"

When I try this it appears on 2 lines but I want it to appear on one.

Any ideas?

Ta

Andi


"Bob Phillips" wrote in message
...
Use a Chr(10), for example

msgbox "hello" & Chr(10) & "goodbye" & chr(10) & "taht's it"

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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