Hello
I would like to have a progress bar in some of my userforms.
As an example i attach a sample.
Thanks in advance for any assistance here!![]()
Hello
I would like to have a progress bar in some of my userforms.
As an example i attach a sample.
Thanks in advance for any assistance here!![]()
What progress do you want to monitor...?
The sample user form is a data entry/search (didn't take the time to look) form, there's no progress to report, is there?
Thanks for looking at this.
In my example the confirm button transfer data of userform to the second sheet.
I'd like to monitor this progress.
Updating 5 cells in a loop that iterates once is not something that needs a progress bar... in my opinion. You're adding needless complication/overhead to something that is practically instantaneous.![]()
Please Login or Register to view this content.
Thank you very much for your advices.
As i said in my first post..
I have many codes that take many seconds to run. So i need this progress bar for these codes... would like to have a progress bar in some of my userforms.
As an example i attach a sample.
So do you have any idea for how a progress bar could works in my example?
You change its value:
![]()
Please Login or Register to view this content.
Everyone who confuses correlation and causation ends up dead.
Yes this works. Thank you.
Altrough i don't understand what do you mean when you say: "You change its value"
Also if you don't mind, may i ask this?
Will always use the same criteria? I mean that in my code there are 6 different trandfer so you used 6 different levels for the progreessing bar. So is this the way that i have to use when i use a progress bar?
I mean you change its value using code like this:
You will need to work out what the value should be based on how many steps you have to perform, and how many you have completed.![]()
Please Login or Register to view this content.
I believe that i get the logic!
Thank you very much.![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks