Progress Bar ?

C

CPhil

I've written a macro that is used by others at my work. It's
accesssed/run through a userform that covers the whole screen, so all
the flickering is avoided. The only downside is that, as the macro
takes some time to run, to some people, it appears that nothing is
happening.

I tried to create a progress bar by putting textboxes side by side and
then changeing the backcolours of these at various points though the
code, but found that this didn't work (although it did work when
stepping through the coded step by step!).

Does anyone know a way to indicate the progress as the macro runs ??
 
A

Andy Pope

Hi,

If your code is working in step mode then it sounds like you need to add
a DoEvents command within the loop so that the labels can update.

psuedo code would be

top of your loop
do some things...
update progress

DoEvents
end of your loop

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

Similar Threads

How to clear prior search terms from Navigation Pane 0
VBA Export to PDF 0
MS Project. Real progress of the project, % complete 1
Menu Macro Not Executing - Need Help 1
Setting column width in a table with a macro is not working 0
Progress indicator help wanted 2
Progress Bar won't work in Excel 2007 6
Implement a progress bar when the macro run inside another workboo 2

Top