I have a listbox, and I am going thru it 1 item at a time, how can I make it so that I have a Progress Bar show how far it is gone thru the list ?
Printable View
I have a listbox, and I am going thru it 1 item at a time, how can I make it so that I have a Progress Bar show how far it is gone thru the list ?
I don't understand the first part of your question, but as for breaking out the name, if the full name/extent has only one period, then
nameonly = left (fname, instr(1, fname, "."))
will work fine. If more than one period can be there, you have to create a reverse instr function to scan from the right.
Thanks, but I figured it out, so I changed the topic of the post, read it again :)
the progress bar has two things that you need be concerned.
1) A value that represents the end (Progressbar.max)
2) A value that represents a number between 0 and the end(progressbar.value).
You set the end value before you start the iteration.
You keep setting the progress value during each iteration.
You will undoubtedly need to do a progressForm.refresh or doEvents inside the iteration loop.
What exactly made this urgent?
You place a progress bar on the form.
progressbar1.min = 0
progressbar1.max = 100
now to change the values
progressbar1.value = progressbar1.value + 10 (for example)
also, you want to check that if progressbar1.value = 100 then upon addition, it just stays the same or goes back to 0.