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

I give up - I can only presume that the maximum size of a MSGBOX is
dependent on your screen size and configuration. As a result I will give up
on this simple approach and have to do something a bit more involved.

Thanks for you help though :-)

Andi


"Bob Phillips" wrote in message
...
Guess what - one line for me/

This is how I understand MsgBox to work.

--

HTH

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


"Andibevan" wrote in

message
...
Apologies again, I copied the wrong line - it also appears correctly on
mine

This one does appear on 2 lines on my screen.
MsgBox "Copy Information from:- C:\Documents and Settings\abevan\My
Documents\SM Parti\Drive_H\WIP\WIP - Weekly

Checkin\Start\blahblahblahblah"

Maybe there is a way to turn of word wrapping in a message box?


"Bob Phillips" wrote in message
...
When I run that, it all appears on one line !

--

HTH

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


"Andibevan" wrote in

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