ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   "Modeless" Message Boxes? (https://www.excelbanter.com/excel-programming/290700-modeless-message-boxes.html)

Mark Worthington

"Modeless" Message Boxes?
 
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

Bob Phillips[_6_]

"Modeless" Message Boxes?
 


--

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




Bob Phillips[_6_]

"Modeless" Message Boxes?
 
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




Shailesh Shah[_2_]

"Modeless" Message Boxes?
 
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!

Mark Worthington

"Modeless" Message Boxes?
 
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


All times are GMT +1. The time now is 11:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com