I would like to be able to move a Message Box when it appears, so that
I can see behnind it before making a decision. However, as it moves,
it effectively justs wipes the screen clear .... I'm familiar with
modeless UserForms, is there a way to make a Message Box act like this
(not so mas to actually access the worksheet, but to be able to see
everything first).

Cheers for any help,

Mark

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Mark Worthington" wrote in message
om...
I would like to be able to move a Message Box when it appears, so that
I can see behnind it before making a decision. However, as it moves,
it effectively justs wipes the screen clear .... I'm familiar with
modeless UserForms, is there a way to make a Message Box act like this
(not so mas to actually access the worksheet, but to be able to see
everything first).

Cheers for any help,

Mark

Mark,

I don't get this problem myself, moving the message box does just what you
want.

However, you could always build a userform to display the message, it would
be a very simple form, and make this modeless.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Mark Worthington" wrote in message
om...
I would like to be able to move a Message Box when it appears, so that
I can see behnind it before making a decision. However, as it moves,
it effectively justs wipes the screen clear .... I'm familiar with
modeless UserForms, is there a way to make a Message Box act like this
(not so mas to actually access the worksheet, but to be able to see
everything first).

Cheers for any help,

Mark

Hi Mark,

It seems that you have using Application.screenupdating=false

So before popup msgbox you have to again set it to true.

Application.screenupdating=True
msgbox "Now move the msgbox"



Regards,
Shah Shailesh
http://members.lycos.co.uk/shahweb/


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

It seems that you have using Application.screenupdating=false

So before popup msgbox you have to again set it to true.

Application.screenupdating=True
msgbox "Now move the msgbox"


Bob & Shah Shailesh,

Yes, I finally worked it out, doh! I use
Application.screenupdating=False as a default, and recently updated my
error handling ... inadvertantly messing up some message boxes. Thanks
for your help,

Mark