LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 921
Default Progress Bar

Hi -
I have a macro that takes quite some time. There are several loops that run
inside of it to delete or consolidate rows (which can be up to 40,000 rows).
The macro can take about 20 seconds to 1.5 minutes. I would like to create a
Progress Bar to let the user know that how long to expect (and that the macro
is actually running...). I have viewed the website
http://www.enhanceddatasystems.com/E...rogressBar.htm , but I do
quite understand how to incorporate this into my macro.

If anyone has any suggestions, I would really appreciate it.

Thank you in advance.
--
Jeff
 
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
Progress Bar leerem Excel Discussion (Misc queries) 2 August 13th 08 05:16 PM
Progress Bar PAL Excel Worksheet Functions 3 August 13th 08 03:28 PM
NEED Help - How to capture the Event's progress in Progress Bar Sriram Excel Programming 6 August 22nd 06 12:04 PM
Progress Bar swestwood Excel Programming 2 February 8th 06 04:31 PM
Progress Bar dcronje Excel Programming 0 September 30th 04 04:32 PM


All times are GMT +1. The time now is 07:03 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"