mqdias
11-22-2012, 03:46 AM
Hi, i think i need some help with my progress bar.
In this webstie i find great this including some examples of progess bars.
As you may see by the attachment, there is a button in Sheet1 named "Show progress" that shows the variety of progress bars that the creator of this file did, and i created my own "CommandButton1" to test it for my use.
I have imported and arranged the code to UserForm2 that i've created, which a has only the progress bar so when i click "CommandButton1" in Sheet1, it starts running the progress bar.
What happens is that when i click the "CommandButton1" the userform isn't shown during the progress bar code and is only showed at the end with the 100% value...
Can anyone give me an idea how can i put the userform to be shown ?
Thanks!
In this webstie i find great this including some examples of progess bars.
As you may see by the attachment, there is a button in Sheet1 named "Show progress" that shows the variety of progress bars that the creator of this file did, and i created my own "CommandButton1" to test it for my use.
I have imported and arranged the code to UserForm2 that i've created, which a has only the progress bar so when i click "CommandButton1" in Sheet1, it starts running the progress bar.
What happens is that when i click the "CommandButton1" the userform isn't shown during the progress bar code and is only showed at the end with the 100% value...
Can anyone give me an idea how can i put the userform to be shown ?
Thanks!