Progress bar for loading Userform

Can you upload an example workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

Hi,

Create a new user form which contains just two controls, one control that's set to the maximum width of the progress bar and the other which is overlaid on the top and whose width is set every time you add another control to your main form. If you are using a looping macro to load the controls than you can easily add an instruction to set the width each iteration through the loop. If you are adding controls from a long list in VBA then you'll need to have a line to set the progress bar width each time.

Are these controls being added at run time? How many controls does your userform have that there is a noticeable delay in loading?

The problem is knowing how long it takes to load your userform.
Heres a progress bar that you can set a time for it to run.
If you call the progress bar first and you can call the userform within the timer procedure.
you will just need to set your time and also put some code in to show completed once loaded.

Originally Posted by idinuv

I am able to create the progress bar. On standalone basis... the progress bar Macro is running.

What I am looking is a way to "start the progress bar when I initiate the userform and finish it when my userform loads completely".

Yes I realise that which is why I suggested that you create a new form which will contain the progress bar (or use the one you have) and which is loaded immediately you initialise the controls form. You'll probably need to set the modal property of both to False.

Hello idinuv,

As reported by apo: "Crosspost: http://www.ozgrid.com/forum/showthread.php?t=189156"

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

Regards.

What is it that's making the userform slow to load?

Do you have code that's populating controls on the form?

If you do can you post it, or even better attach a sample workbook.