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

Hi Steven,

5. I have found a few examples on the web showing progress bars but
I can't seem to figure out how to increment the progress bar while
it runs through my macro.


The progress bar obviously is on a userform, so you need to show the
form too.

Before your loops start, add:

ProgressBar.Show vbModeless

Then when done, don't forget to hide and destroy the form:

ProgressBar.Hide
Unload ProgressBar

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

 
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
Excel progress bar MeTheITGuy Charts and Charting in Excel 5 March 28th 07 10:51 PM
NEED Help - How to capture the Event's progress in Progress Bar Sriram Excel Programming 6 August 22nd 06 12:04 PM
Excel Status Progress Bar Ai Excel Programming 2 May 28th 04 01:41 PM
Excel VBA Progress bar on a userform Bo_[_2_] Excel Programming 3 May 28th 04 01:00 PM
Excel and Progress Fred Smith Excel Programming 3 April 28th 04 05:23 PM


All times are GMT +1. The time now is 10:11 PM.

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

About Us

"It's about Microsoft Excel"