Resize Message Box
That may well be it. I have a resolution of 1600x1200 on my laptop, so I get
quite a bit of real estate.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Andibevan" wrote in message
...
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
|