Creating a Progress Bar

A little more of a roadmap to your code would help. You have a couple of places with very similar code to the excerpt you provided. I believe this is from the sub CreateWorkbook.MergeandFillHeader.

Would also help to tell us specifically what "I cant get it to work" means.

Also helpful to tell us how to run your macro.

The code you said you are trying does not appear in the file. However, it seems that the problem is that you have a For loop that iterates using i, and then inside that you have a For loop that iterates using i. Not a good practice. I find your code confusing in that your existing code is looping through the array v, but the code you showed (and aren't using) loops through rows.

Anyway, here is the best guess I can take at this. Also note that Progress must be modeless. I cannot run your code because it opens other workbooks that I do not have. I attached the modified file. I marked my changes here:

Please Login or Register  to view this content.

Originally Posted by allenayres83

This worked perfectly. Thanks so much

Which one?

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking addreputationiconsmall.jpg below their name.

This is the code that worked. I thought I quoted this before but guess I messed that up.

Originally Posted by 6StringJazzer

Anyway, here is the best guess I can take at this.

You can't do a progress bar for that because to VBA a web query is an atomic operation. (Your other situation had a loop so you could update the progress every time through the loop.)

I don't know why your form is showing up white. I once had a similar issue and forced it to repaint. I don't know if that will work for you. Try putting this line right after the Show line:

Please Login or Register  to view this content.

This worked for me. Thanks so much