Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default 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/


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 194
Default 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/



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
macro to display message,when open workbook puiuluipui Excel Discussion (Misc queries) 7 October 13th 09 12:39 PM
Display a message when a macro is executing alexrs2k Excel Discussion (Misc queries) 2 September 11th 09 05:20 PM
Display message upon file open even with macro security set to high [email protected] Excel Discussion (Misc queries) 1 November 11th 06 02:43 PM
Display a message whilst a macro runs steve Excel Programming 0 October 29th 03 07:37 PM
Display a message whilst a macro runs Tom Ogilvy Excel Programming 0 October 29th 03 12:43 PM


All times are GMT +1. The time now is 08:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"