![]() |
"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 |
"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 |
"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 |
"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! |
"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