"Bouncing Bar" progress indicator control?

G

Greg Lovern

I've been asked to see if it's possible to get a "bouncing bar"
progress indicator control in Excel.

A "bouncing bar" is the kind of progress indicator that looks like a
normal progress indicator, but instead of the bar filling up from left
to right, a short section of bar bounces from left to right,
indicating that the program is busy but not indicating how much
progress has been made -- as for a database retrieval, where you don't
know how long the task is going to take.

Any suggestions?


Thanks,

Greg
 
B

Barb Reinhardt

I use Application.StatusBar to display that type of information. You need
to do some calculations to get it to work though.

HTH,
Barb Reinhardt
 
G

Greg Lovern

Thanks, those look great.

But if I put the code that retrieves the database data where your code
indicates, wouldn't Excel stop to retrieve all the data before
animating the progress indicator?

Is it possible for an ADO database data retrieval to be asynchroneous,
so that I can animate your progress indicator while it runs?


Thanks,

Greg
 
A

Andy Pope

If all of the delay is whilst executing 1 statement, in your case a
retrieval of data, any coded approach will not work.

What you could do is use an animated gif in a webbrowser control on a
userform. But unless the delay is really long a simple 'Please Wait' is
best. Ivan F Moala has an example.
http://www.xcelfiles.com/Excel04.html#anchor_59

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top