Is there a way I can show the progress of a long piece of code by
showing information on a UserForm, even when
application.screenupdating=false?

If the screen isn't updating the information being written to the form
isn't displayed until the application.screenupdtaing=true.

If I leave application.screenupdtaing=true the code takes longer to run
and it makes the screen flicker (in a really annoying fashion!)

I hope there is a way where I can have UserForms updating with the rest
of the application not updating?


I hope someone out there can help me, as I am really stumped on this one.


TIA

My experience does not concur with yours.

If you have a progress userform, initiate your code from within there. Your
code should keep updating the form, but that will work fine with no
ScreenUpdating.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"SmilingPolitely" wrote in message
. au...
Is there a way I can show the progress of a long piece of code by
showing information on a UserForm, even when
application.screenupdating=false?

If the screen isn't updating the information being written to the form
isn't displayed until the application.screenupdtaing=true.

If I leave application.screenupdtaing=true the code takes longer to run
and it makes the screen flicker (in a really annoying fashion!)

I hope there is a way where I can have UserForms updating with the rest
of the application not updating?


I hope someone out there can help me, as I am really stumped on this one.


TIA

I assume that your code is in some type of loop.
In which case, include the statement
Me.Repaint
after the progress bar is updated.

Kevin Beckham

-----Original Message-----
Is there a way I can show the progress of a long piece of
code by
showing information on a UserForm, even when
application.screenupdating=false?

If the screen isn't updating the information being
written to the form
isn't displayed until the application.screenupdtaing=true.

If I leave application.screenupdtaing=true the code takes
longer to run
and it makes the screen flicker (in a really annoying
fashion!)

I hope there is a way where I can have UserForms updating
with the rest
of the application not updating?


I hope someone out there can help me, as I am really
stumped on this one.


TIA

.

I am not actually using a progress bar. I am progressively adding text
to a textbox that explains to the user exactly what the code is doing at
the time.

?? Maybe I should be using a progress bar too ??

I will give the repaint a go and see how that goes. Thanks for your input.


:-D


Kevin Beckham wrote:

I assume that your code is in some type of loop.
In which case, include the statement
Me.Repaint
after the progress bar is updated.

Kevin Beckham


-----Original Message-----
Is there a way I can show the progress of a long piece of

code by

showing information on a UserForm, even when
application.screenupdating=false?

If the screen isn't updating the information being

written to the form

isn't displayed until the application.screenupdtaing=true.

If I leave application.screenupdtaing=true the code takes

longer to run

and it makes the screen flicker (in a really annoying

fashion!)

I hope there is a way where I can have UserForms updating

with the rest

of the application not updating?


I hope someone out there can help me, as I am really

stumped on this one.


TIA

.

I've never used it myself, but myabe this would be of use?

http://www.cpearson.com/excel/Progress.htm

Pete.

-----Original Message-----
Is there a way I can show the progress of a long piece of
code by
showing information on a UserForm, even when
application.screenupdating=false?

If the screen isn't updating the information being
written to the form
isn't displayed until the application.screenupdtaing=true.

If I leave application.screenupdtaing=true the code takes
longer to run
and it makes the screen flicker (in a really annoying
fashion!)

I hope there is a way where I can have UserForms updating
with the rest
of the application not updating?


I hope someone out there can help me, as I am really
stumped on this one.


TIA

.