progress bar

Hi, the code below is to import file names into excel from any given folder. I'd like to have a progress bar but I'm not sure how it would work. I thought if I could work out how many file names are going to be imported before the Macro does it's work, I could use it to do a progress bar...

HI there VBA Guru's I am using the following code to filter some Pivot Tables on a worksheet, however it takes sometime to run the marco, I would like to have a progress bar in the user form to show the progress of the macro. however I have not been able to insert a progress bar into the user...

Hello, I have a VBA code that calculates random numbers for about 5 seconds, it it possible to add a Progress bar to the excel sheet? If so where could I find the control?

Hi, I am trying to create a progress bar from charts and am stuck. I am trying to create create 3 subprogress bars within 1 overall bar. Here is my example. I have 100 items that get processed in 3 stages. 80 items have completed stage 1. 60 items have completed stage 2 20 items have...

Ok, so I am looking to do a very simple progress bar and need some help with the code. I am still learning VBA and can't quite figure out this one. What I am looking for is something like this: Sub MyMacro() Create a progress bar window with the indicator at 0 Run the first part of my macro...

I have modified a progress bar that was made by Andy Pope, however I can not get it to work. When I set the form to modeless it appears blanked out on the screen, when I run it in normal mode it works perfect but my code will not work until the progress form has finished running it's course...

Hi All, I currently am using a very lengthy macro that opens and updates 30 other spreadsheets. It currently takes between 9 and 15 minutes depending on what is doing. I have a very basic screen update built into it that shades a progressive cell in black to show its progress. I have...

Hello People, I have a macro which takes a looong time to execute - opening 20+ files and copying information from each into one master file. I have used the application.screenupdates = false command to stop the screen jumping all over the place while this happens, which is a greaet improvement...

Hello all. Sorry - this is a bit drawn out.... I have a large 2 sheet database and a macro that compares matched cell info on each line of each sheet. On finding a match the macro tabulates the findings (departmentises each group). All works great. I also have a progress bar (in smoothed mode)...

Hello All, I implemented the "custom dual progess bar" per the instructions in the link below and the demonstration works good ("ShowForm") in my file. However, it is not being applied to the macros that already exist in my file. Is there possibly some code missing which would show allow me to...

I've gathered that it's not possible to place an animated GIF like this: in a userform in Excel. As you might have guessed, I've created a macro that, depending on user inputs, can take a bit of time to run, and I want to display something to let the user know that Excel hasn't locked up...