Dowsey1977
12-09-2005, 06:13 AM
Hi All,
I have been trying to work out how to do a progress bar for ages now, and don't feel I'm getting any closer, so I thought I'd see if there is anyone in here that can help!
I get the bit about how to create the userform, and have checked out an example on the Microsoft site, which I've also seen on other sites like this one. But, what I am trying to do is run a macro that will filter a few sheets, and then copy the data from each sheet onto a blank sheet that fits the criteria. That I bit I can also do, it's just how to get the progress bar to update, as this isn't a loop, which seems to be a pre-requisite.
Any ideas?
:dunno :help
I have been trying to work out how to do a progress bar for ages now, and don't feel I'm getting any closer, so I thought I'd see if there is anyone in here that can help!
I get the bit about how to create the userform, and have checked out an example on the Microsoft site, which I've also seen on other sites like this one. But, what I am trying to do is run a macro that will filter a few sheets, and then copy the data from each sheet onto a blank sheet that fits the criteria. That I bit I can also do, it's just how to get the progress bar to update, as this isn't a loop, which seems to be a pre-requisite.
Any ideas?
:dunno :help