Prevent Screen Flicker when Showing Progress bar Userform

[realniceguy5000]

Hi It has been a while but found an issue I cant seem to work out.

I have a userform with a progress bar that I want to update as the script runs. I got the progress bar script from Andy Pope web site and tried to insert my logic, Everything runs except I have a large amount of screen flicker, but only in the part in red below, after this completes the rest of the progress bar has no flicker.

As you can see below I tried to make the progress bar update as my logic updates records, however I may be going about this the wrong way. If I don't update the bar is this way then the bar holds on 1 till all the updates are complete then moves pretty quick to 100 %

I would like to keep the progress bar moving as each update are completed, I had to place the "DD" in to count the rows so the bar would not go past 100 % I'm sure someone will have a better understanding of what I mean by reading through the code below.

Thanks as always for any help you can provide.
Mike

Note: All this code is in the Userform

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[realniceguy5000]

I was able to create a solution via a couple extra statements, seems to work fine now, no more screen bounce and the bar updates as the script runs.

Mike

Please Login or Register  to view this content.