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 ??


--
CPhil
------------------------------------------------------------------------
CPhil's Profile: http://www.excelforum.com/member.php...o&userid=29842
View this thread: http://www.excelforum.com/showthread...hreadid=532295

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

CPhil wrote:
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 ??



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Search thru this forum and there are number links to website demonstrating
how to add in a progress bar
http://www.dailydoseofexcel.com/arch.../progress-bar/
http://www.j-walk.com/ss/excel/tips/tip34.htm


"CPhil" wrote:


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 ??


--
CPhil
------------------------------------------------------------------------
CPhil's Profile: http://www.excelforum.com/member.php...o&userid=29842
View this thread: http://www.excelforum.com/showthread...hreadid=532295