Userform as progress bar when unloaded only shows to 40%

[Whitethorn]

Hi all,

Hoping you can help. I'm using a progress bar and have got it working fine - it goes up to 100% as i require it to, however it doesn't close automatically when it gets to 100%

To close the progress bar I am using the unload function. However, the progress bar only shows the progress until 40% and then closes.

I just wondered if there was another way to close the progress bar so that it happens after 100% is shown?

Thank you

[CK76]

Hard give you specific answer without code or sample workbook.

Generally speaking, if you are using UserForm.Bar.Width method to show progress...

You can just check that Bar.Width has reached some set value before Unload is used.

Ex: When I used pctComl = current/total * 100

Please Login or Register  to view this content.

[Mr.PB]

Are you using the form.repaint method? Might also toss in DoEvents for good measure.

[Whitethorn]

Thank you, appreciate the help.

unfortunately can't post code due to sensitivity

Using the above gives me the same problem. Starting to think that maybe the last bit just executes so quickly that it doesn't have a chance to really update the progress bar

[CK76]

If userform is too slow to display...

Perhaps you can use alternate method of showing progress using status bar.

Ex: Originally posted by me in another forum.

Please Login or Register  to view this content.