Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 119
Default msg box while operation is running.

Hi Kevin,
Another is to use a Text Box e.g. for "Text Box 12"

At the start of code

ActiveSheet.Shapes ("Text Box 12").Visible=True

and at the end

ActiveSheet.Shapes ("Text Box 12").Visible=False

Bear in mind though the text box is always there even if you can't see it :)

Regards,
Don

"Keivn Green" wrote in message
...
Is there a way to make a message box come up only while a macro is running
and then have it go away once the procedure is done?



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
what does $ operation mean JO New Users to Excel 1 December 15th 05 11:42 PM
msg box while operation is running. Tod[_4_] Excel Programming 1 August 28th 04 12:11 AM
Slow operation Mark B. Lloyd Excel Programming 1 April 28th 04 10:12 PM
Illegal Operation Angela[_4_] Excel Programming 0 October 3rd 03 03:38 PM
Operation on Ranges JohnI Excel Programming 1 September 2nd 03 05:00 PM


All times are GMT +1. The time now is 03:52 PM.

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"