Display message in macro
 

Create a "Please wait...." form

Create a new macro to open that form

Call your existing macro on the form load of that new form

HTH
-Merk


11/25/03 10:29AM
How do I display a message to the screen from within a macro saying"Please wait...." while the macro runs withApplication.Screenupdating=False. I am using Excel 97 & Windows 98?------------------------------------------------~~ Message posted from http://www.ExcelTip.com/~~View and post usenet messages directly from http://www.ExcelForum.com/

Display message in macro
 

How do I display a message to the screen from within a macro sayin
"Please wait...." while the macro runs wit
Application.Screenupdating=False. I am using Excel 97 & Windows 98

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

Display message in macro
 

You might also try he

http://j-walk.com/ss/excel/tips/tip34.htm

http://www.bmsltd.co.uk/Excel/Default.htm

http://www.andypope.info/vba/pmeter.htm



Try a Google search of the newsgroups for "Progress Indicator". (If you
don't have Ron DeBruin's excellent Google Search add-in, it's at
http://www.rondebruin.nl/Google.htm.)



Ed



"SteveMcD" wrote in message
...

How do I display a message to the screen from within a macro saying
"Please wait...." while the macro runs with
Application.Screenupdating=False. I am using Excel 97 & Windows 98?


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

Display message in macro
 

Thanks, that works very well

Stev

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com